TOP 100 at "SQL Exercises"

May 25, 20:57 MSK

SQL Exercises is intended for acquiring good practical experience, which is focused on data operation, namely on SQL DML. Certain exercises for beginners are provided on the site, they are supplied with the necessary reference source on SQL syntax with a great number of examples. Apart from them, 3 rating stages are suggested, they are aimed at testing of specialists and their certification. The source is absolutely free of charge, and the certificate purchase has a voluntary basis.
NOTE: Your browser should support Cookies and Javascript to provide correct usage of this site. If you use content filter, it should allow opening child windows to explore help pages.

Ratings

  • Top 100
  • Top 100 on latest exercises
  • "Liberal" rating
  • Olympic rating
  • TOP 100 of Learning Stage
  • Rating by summation of ranks
  • Top 10 (photos)
  • Last-week results
  • Rating of second-stage exercises (average)
  • Rating of 2nd-stage exercises (median)
  • Author's rating  • 2nd stage rating up to exercise:
   enter No 
  • Rating on the exercise:
   enter No
  • Optimistic rating
   enter factor

Statistics

  • Today statistics
  • Site's old residents
  • Recent leaders activity
  • Сhanges in exercises' TOP 10
  • Results' chart

SQL exercises

  • Site rules
  • SELECT (learning stage)
  • SELECT (learning stage,
      choosing DBMS)
  • SELECT (rating stages)
  • DML 
  • Transact-SQL tests
  • Data simulation
  • Visual simulation (painting)
  • Exercises voting

Forums

  • Learning stage
  • Rating stages
  • Favorites
  • Search
  • Blogs

Certification

  • Certified professionals
  • Statistics
  • Statistics over regions (map)
  • Confirm certificate

HELP

Query optimization

For employers

Support SQL-EX.RU

Дизайн криотерапия здесь
lantanclinic.ru
Монтаж пожарной сигнализации
Проектирование, монтаж и обслуживание систем безопасности для дома и офиса
paritetsar.ru

Top 100	Candidates How the rating position is calculated
Involved in rating: 12588 Involved in second stage rating: 3353

No	Person	Number of Sel_ex	Last_Sel	Number of DML_ex	Scores	Days	Days_2	Days_3	S_3	LastSolved	LastVisit
1	Chernov D.V. (Kursist)¹	271	306	42	675	1261	1602.231	1710.766	251	2020-04-18	2020-05-24
2	Doschenko V.N. (mcrain)¹	256	234	42	645	3111	2043.043	524.573	251	2020-04-08	2020-04-15
3	Krasovskij E.A. (pegoopik)¹	269	262	42	673	3441	210.551	14.367	248	2019-12-09	2020-05-02
4	Kostomarov A.V. (al29)¹	258	262	38	647	2617	4143.636	2280.824	248	2019-06-25	2020-05-25
5	Kreslavskij O.M. (Arcan)¹	269	306	42	672	4825	284.256	225.461	245	2020-04-18	2020-05-21
6	Boiko D. (Angellore)¹	264	12	40	655	4303	5238.079	3825.743	237	2019-05-23	2020-04-02
7	Bezhaev A.Yu. (Baser)¹	260	227	34	640	2924	201.513	178.821	233	2018-05-04	2020-03-30
8	Dubinskij A.V. (_velial)¹	259	12	42	650	3694	2797.486	3371.376	227	2019-12-25	2020-05-24
9	Karasyova N.V. (vlksm)¹	262	262	42	650	5095	291.904	242.771	224	2020-04-25	2020-05-14
10	Kurochkin P.A. (qwrqwr)¹	256	306	40	630	3813	257.786	164.392	211	2020-04-19	2020-05-25
11	Vyazovetskov A.S. (alex_v)⁹	238	161	23	560	4361	177.452	94.196	204	2018-05-17	2020-03-11
12	Filippkin D.V. (_dimon_)¹	252	306	42	630	4105	195.574	127.909	202	2020-04-18	2020-05-18
13	Movlyanov A.P. (Oct)⁷	242	10	29	586	1307	2353.723	2448.847	193	2017-01-23	2018-08-27
14	Sal'nikov S.A. ($erges)¹	225	206	25	549	2533	17.505	14.498	181	2015-02-02	2020-05-14
15	Kukushkin S.A. (smog)⁹	223	163	29	525	2368	1054.562	1122.181	153	2017-10-03	2020-04-16
16	Yatsuk A.A. (Faust_zp)¹	184	255	24	457	1984	144.150	108.840	137	2012-07-12	2019-02-15
17	Kuznetsov V.S. (herrRo)¹	169	260	23	416	1167	478.511	73.335	122	2012-02-08	2013-06-18
18	Grinkevich D.L. (Dmitrij Grinkevich)¹³	202	10	27	465	2059	367.128	932.343	109	2017-05-31	2020-04-25
19	Drozdkov A.N. (anddros)⁵	190	16	24	443	2244	12.341	11.091	108	2014-07-21	2015-01-29
20	Varenikov D.M. (Dmitriy Varenikov)²⁰	210	12	42	498	3392	2659.558	1790.601	104	2020-02-08	2020-03-23
21	Shindin A.V. (AlShin)¹	156	44	23	385	3621	409.202	777.457	99	2018-09-18	2018-10-06
22	Zajtsev V.S. (Sleeping)¹⁹	207	184	27	457	3601	1040.053	1327.686	98	2018-04-17	2019-03-04
23	Timofeeva E.V. (Umrikhina)¹	207	40	41	498	4234	50.530	47.237	96	2019-11-27	2019-12-30
24	Aliev R. (y4nzi)²¹	210	187	33	487	236	64.714	37.753	95	2018-01-25	2019-03-24
25	Tarasov D.B. (Gavrila)⁹	162	15	23	391	2427	151.343	99.710	95	2012-04-23	2018-01-08
26	Orlov M.V. (Eagleoff)⁹	149	258	23	367	952	138.468	106.466	92	2011-11-10	2019-12-05
27	Zotov P.G. (Ozzy)¹	147	-16	23	364	1412	213.524	187.364	83	2012-02-05	2016-08-18
28	Derzhal'tsev V.A. (MadVet)³	136	100	22	337	2073	143.349	99.698	81	2010-12-29	2015-10-14
29	Pusev D.V. (Pusev_Denis)²⁹	174	200	40	426	887	858.523	922.622	69	2020-05-23	2020-05-23
30	Agapov V. (KERBEROS)¹	159	253	24	384	2409	35.562	27.703	69	2013-04-02	2016-09-24
31	Sigankov V.I. (vasilyvanc)³¹	197	176	42	462	2244	127.746	46.597	65	2020-05-13	2020-05-25
32	Fedevych V.I. (labuch_fedev)³⁰	197	167	40	457	2241	866.391	1557.429	65	2020-04-20	2020-04-20
33	Petrov Y. (YuriPetrov)²¹	197	12	40	455	3061	63.417	24.005	64	2019-07-04	2019-09-15
34	Shkarednyj I.N. (Gosha)³¹	192	193	41	452	4947	1097.093	486.249	64	2019-08-13	2020-05-25
35	Koptel'tsev V. (selber)³⁴	200	158	42	479	2822	1930.386	733.207	63	2020-05-13	2020-05-25
36	Williams B. (BW)³¹	201	12	41	462	4001	4685.117	2394.036	63	2020-02-20	2020-05-21
37	Chebykin D.N. (GriGrim)²⁵	201	40	34	461	3849	815.976	380.694	62	2019-12-29	2020-02-12
38	Shaymardanov M.M. (xLiSPirit)¹⁹	178	203	34	428	2792	426.854	528.104	62	2018-05-18	2018-12-20
39	Kalinin K.A. (kalinin_k)¹⁶	152	169	23	358	391	26.206	36.659	60	2012-06-30	2014-11-19
40	Dvoryaninov V. (Valdaj)¹⁶	151	2	23	350	1499	405.533	329.316	55	2013-08-14	2020-04-28
41	Fokin A. (Vizitor )³³	184	261	41	453	2904	60.519	1133.759	52	2019-08-17	2019-09-06
42	Murashkin I.V. (lepton)¹	94	90	21	219	2188	131.386	645.720	51	2012-03-20	2014-03-10
43	Halushka B. (halushka)³³	157	35	20	364	284	131.302	58.407	46	2015-10-19	2016-01-22
44	Titovskij P.S. (kli3ma)²³	167	45	28	399	1903	27.479	17.959	45	2016-06-15	2016-06-15
45	Utyonkov M.N. (=Maxim=)²⁰	174	95	24	388	4533	48.983	11.750	42	2018-10-08	2018-12-11
46	Sysoev A.V. (Sysa)³⁸	121	174	22	257	3225	6163.368	2114.921	39	2016-09-07	2017-11-30
47	Sviridov K.Yu. (orange)¹⁹	123	-16	23	301	1591	62.221	31.081	38	2012-05-17	2012-05-22
48	Senkevich S.V. (GreyC)¹	90	-7	21	222	392	55.287	23.321	38	2009-10-06	2014-03-15
49	Seleznyov A.S. (Artyom S.)¹	87	106	21	214	444	46.448	30.368	38	2009-01-25	2010-09-08
50	Latyntsev N.G. (aks_nsk)⁴⁵	188	174	40	440	2640	35.056	7.501	37	2019-05-21	2019-11-24
51	Vakhrameev A. (WY)³⁴	171	52	25	391	1445	39.011	9.069	36	2015-01-18	2018-02-11
52	Pechatnov V.V. (pvv)¹	118	15	21	278	1992	40.086	15.512	33	2013-04-05	2016-10-29
53	Martynyuk (Wiedzmen)²¹	154	120	23	350	2189	1691.989	1692.363	32	2015-03-10	2016-02-08
54	Nikotin V.M. (@Nikotin)¹	88	4	21	216	235	7.697	3.541	32	2009-04-23	2012-11-08
55	Pyatiletov A. (MontaG)⁵⁴	180	12	39	412	2480	95.263	28.667	30	2019-06-30	2019-06-30
56	Pavlov A.V. (Anton)⁵⁰	178	228	40	415	5011	3238.123	1187.402	29	2019-06-11	2019-08-18
57	Nashyn E. (O.o)²³	125	2	23	290	1159	183.142	77.876	29	2013-09-13	2014-11-28
58	Zin4uk V. (Zin4uk Vadim)³³	144	103	24	341	1334	154.722	42.752	28	2014-06-24	2014-09-02
59	X D. (railgun3r)²⁸	151	104	24	352	1369	320.237	750.766	26	2014-08-16	2015-11-03
60	Mullakhanov R.Kh. (rem)⁹	90	-6	22	216	238	14.329	9.679	26	2009-06-20	2010-02-02
61	F (uff)⁵¹	177	69	31	405	1504	1073.788	952.124	25	2018-01-22	2018-08-20
62	Sivoglazov M.A. (Gaizenberg)⁵¹	157	142	24	356	801	288.645	35.424	24	2015-11-10	2020-03-05
63	Vas'kov E.V. (Johan)²	140	58	24	328	2582	544.122	1034.271	24	2013-08-16	2019-04-18
64	Sukhnev D.A. (mz)²²	131	44	23	309	2468	62.106	13.009	23	2013-05-05	2015-10-17
65	Lyubchenko V.A. (IAS56)⁶	99	84	22	235	1454	649.209	138.580	23	2010-09-14	2014-05-06
66	Anisimov D. (danilko)¹³	93	46	22	215	31	12.467	7.708	23	2009-08-12	2009-08-17
67	Egorov Yu.A. (Yury Egorov)⁴⁴	141	197	23	315	1772	19.759	13.689	21	2016-04-16	2016-04-16
68	Fajnberg M.L. (burnall)³⁶	123	185	23	283	1451	220.161	295.352	21	2013-06-05	2014-11-03
69	Golubin R.S. (Roman Golubin)³	79	4	21	188	1412	92.685	58.691	20	2009-07-01	2018-06-15
70	Kudryakov A.I. (AKudrakov)¹⁹	98	85	22	230	756	101.131	52.909	18	2010-02-05	2010-05-05
71	Suprun D. (TimonSP)⁴²	154	115	29	375	3033	11.926	1.721	15	2017-01-09	2019-02-26
72	Azbel' E.G. (enull)⁶⁹	144	143	25	350	3439	1146.218	1004.908	15	2018-02-21	2020-05-05
73	Skorohod I. (Dracul4ik)⁶⁵	144	52	25	346	2295	712.643	584.009	15	2017-09-12	2019-09-10
74	Grishin (alvigr)⁵⁵	142	140	24	323	1095	89.639	756.898	15	2014-12-10	2015-01-19
75	Grecha (grecha)⁵³	139	185	24	317	150	8.813	1.612	15	2014-02-26	2016-03-11
76	Frolov (dr.shtopor)⁶⁶	140	148	28	348	705	306.798	49.878	14	2016-04-05	2019-12-31
77	Egorov A.B. (ABEgorov)²⁰	98	140	22	233	750	15.262	8.506	14	2010-02-26	2011-05-17
78	Nikolaenko A.V. (Shadow77)¹²	89	116	22	210	761	66.350	7.673	14	2009-09-13	2019-10-11
79	Soldatenkov Yu.S. (SolYUtor)²	76	-7	21	179	1413	21.067	4.954	14	2010-04-07	2012-11-08
80	Vojnov P.E. (paparome)¹	97	252	23	223	1923	4.448	.562	13	2010-12-01	2019-05-30
81	Belogurova K. (Katy_Ekb)¹	70	1	21	168	550	10.225	3.593	13	2008-11-27	2015-03-20
82	iglbeat (iglbeat)²³	100	75	21	223	1880	37.093	15.741	12	2012-10-19	2012-10-25
83	Proskurin Yu.N. (Xonner)⁷¹	157	95	29	365	2057	51.178	7.973	11	2018-06-23	2020-01-04
84	Maslyaev V.S. (Velmont)⁶¹	160	45	27	364	2168	131.640	42.061	11	2018-02-02	2019-07-02
85	Donskikh A.V. (Ridan)²⁸	100	71	22	229	1511	699.561	31.402	11	2012-05-09	2017-04-28
86	Grishunin M.F. (MikhailFG)⁸⁵	144	40	38	367	765	113.569	3.897	10	2019-01-25	2019-12-18
87	Polyakov S.G. (Ivanoff Alex)³¹	138	135	24	321	1700	187.082	14.537	10	2013-11-29	2019-11-21
88	Kabanets E.G. (azkaban)⁵⁴	150	43	25	339	2227	1921.772	5.246	9	2015-12-30	2015-12-31
89	Bryzgunov V.A. (lorins_)⁶¹	133	153	23	304	1121	183.078	366.226	9	2013-10-23	2017-11-10
90	Bazavluk M. (DoNotLook)⁶⁶	116	2	23	273	3153	696.167	2966.369	9	2019-07-30	2019-07-30
91	Rybkina T.V. (Rybka)³⁷	106	145	22	248	156	107.472	18.281	9	2010-08-30	2020-03-22
92	Makarov I.A. (_Bkmz_)³¹	97	85	22	227	741	7.517	.499	9	2010-03-23	2015-04-04
93	Kurbanoff N.I. (Nariman Kurbanoff)³⁸	90	-14	22	205	798	204.959	141.899	9	2010-07-13	2020-05-12
94	Perfilov B.V. (B o r i s)³³	86	252	22	197	666	923.158	561.220	9	2010-03-31	2018-08-13
95	Milenkov (wqer)⁹³	146	-14	42	376	1462	122.641	13.022	8	2020-05-10	2020-05-25
96	Ilyasov V. (VadimI)⁸⁸	148	148	29	360	251	24.746	.546	8	2017-03-13	2017-04-03
97	Valuev D.I. (Fiolent)¹	104	100	23	249	2714	201.205	69.243	8	2011-02-09	2020-05-03
98	Borisenkov D.V. (xuser)²⁶	107	40	26	244	4309	5.130	.699	8	2019-11-22	2020-05-22
99	Vil'danov M. (mar_vi)²⁹	97	36	21	226	1154	107.382	3.028	8	2011-08-23	2012-11-05
100	Glazyrin D.S. (glassman)²⁴	96	-16	22	224	1731	445.793	.420	8	2013-03-14	2018-01-22

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References

Top 100

Involved in rating: 12588 Involved in second stage rating: 3353

Involved in rating: 12588
Involved in second stage rating: 3353