TOP 100 at "SQL Exercises"

May 16, 21: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 (SELECT)
  • Exercises voting (DML)

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
Купить в кредит авто
автомобилей и авто с пробегом
ctcmotors.ru
Рулонные газоны
разные виды. Низкая цена на рулонные газоны
elite-gazon.ru

Top 100	Candidates How the rating position is calculated
Involved in rating: 12945 Involved in second stage rating: 3434

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)¹	272	235	44	679	1576	1602.324	1710.796	252	2021-02-27	2021-05-16
2	Kostomarov A.V. (al29)¹	260	234	38	650	3279	4336.854	2473.965	252	2021-04-17	2021-05-08
3	Doschenko V.N. (mcrain)¹	253	234	43	643	3188	2043.013	524.573	251	2020-06-24	2020-10-07
4	Krasovskij E.A. (pegoopik)¹	266	262	42	670	3441	210.532	14.367	248	2019-12-09	2021-04-14
5	Kreslavskij O.M. (Arcan)¹	270	235	44	676	5140	284.485	225.506	246	2021-02-27	2021-05-16
6	Boiko D. (Angellore)¹	261	12	40	652	4303	5238.023	3825.743	237	2019-05-23	2021-04-25
7	Bezhaev A.Yu. (Baser)¹	259	235	34	639	3954	201.488	178.822	234	2021-02-27	2021-03-16
8	Dubinskij A.V. (_velial)¹	260	306	44	654	4129	2797.630	3371.376	227	2021-03-04	2021-05-08
9	Karasyova N.V. (vlksm)¹	263	235	44	654	5470	291.978	242.823	225	2021-05-05	2021-05-06
10	Kurochkin P.A. (qwrqwr)¹	257	235	44	640	4139	257.863	164.398	212	2021-03-11	2021-05-13
11	Filippkin D.V. (_dimon_)¹	253	306	44	635	4440	195.664	127.950	204	2021-03-19	2021-03-19
12	Vyazovetskov A.S. (alex_v)⁹	235	161	23	557	4361	177.355	94.196	204	2018-05-17	2020-03-11
13	Movlyanov A.P. (Oct)⁷	239	10	29	583	1307	2353.691	2448.847	193	2017-01-23	2018-08-27
14	Sal'nikov S.A. ($erges)¹	222	206	25	546	2533	17.491	14.498	181	2015-02-02	2021-05-11
15	Kukushkin S.A. (smog)⁹	220	163	29	522	2368	1054.543	1122.181	153	2017-10-03	2021-03-20
16	Yatsuk A.A. (Faust_zp)¹	182	255	24	454	1984	144.082	108.840	137	2012-07-12	2019-02-15
17	Pusev D.V. (Pusev_Denis)¹⁷	198	178	40	489	1203	1184.790	1248.848	134	2021-04-04	2021-05-03
18	Kuznetsov V.S. (herrRo)¹	167	260	23	413	1167	478.499	73.335	122	2012-02-08	2013-06-18
19	Varenikov D.M. (Dmitriy Varenikov)¹⁸	220	235	44	518	3802	4768.549	3076.338	115	2021-03-24	2021-04-26
20	Grinkevich D.L. (Dmitrij Grinkevich)¹³	199	10	27	462	2059	367.105	932.343	109	2017-05-31	2020-08-24
21	Drozdkov A.N. (anddros)⁵	187	16	24	440	2244	12.313	11.091	108	2014-07-21	2020-06-05
22	Shindin A.V. (AlShin)¹	154	44	23	382	3621	409.179	777.457	99	2018-09-18	2018-10-06
23	Zajtsev V.S. (Sleeping)¹⁹	209	12	27	460	4533	1380.133	1327.686	98	2020-11-04	2020-11-03
24	Timofeeva E.V. (Umrikhina)¹	204	40	41	495	4234	50.497	47.237	96	2019-11-27	2021-03-18
25	Aliev R. (y4nzi)²¹	207	187	33	484	236	64.701	37.753	95	2018-01-25	2019-03-24
26	Tarasov D.B. (Gavrila)⁹	160	15	23	388	2427	150.508	99.710	95	2012-04-23	2018-01-08
27	Orlov M.V. (Eagleoff)⁹	147	258	23	364	952	138.434	106.466	92	2011-11-10	2021-01-14
28	Zotov P.G. (Ozzy)¹	145	-16	23	361	1412	212.430	187.364	83	2012-02-05	2016-08-18
29	Derzhal'tsev V.A. (MadVet)³	134	100	22	334	2073	142.798	99.698	81	2010-12-29	2015-10-14
30	Sigankov V.I. (vasilyvanc)³⁰	201	235	44	474	2534	128.500	47.011	72	2021-02-27	2021-05-16
31	Koptel'tsev V. (selber)³¹	204	235	44	494	3112	1959.747	748.732	71	2021-02-27	2021-05-16
32	Agapov V. (KERBEROS)¹	157	253	24	381	2409	35.539	27.703	69	2013-04-02	2016-09-24
33	Fedevych V.I. (labuch_fedev)³⁰	195	167	40	454	2241	866.378	1557.429	65	2020-04-20	2020-04-20
34	Shkarednyj I.N. (Gosha)³¹	192	57	44	456	5478	1097.086	486.249	64	2021-01-25	2021-04-29
35	Petrov Y. (YuriPetrov)²¹	196	57	40	454	3731	63.459	24.005	64	2021-05-04	2021-05-16
36	Williams B. (BW)³¹	198	12	41	459	4001	4685.057	2394.036	63	2020-02-20	2021-03-19
37	Chebykin D.N. (GriGrim)²⁵	201	112	34	461	4205	816.008	380.694	62	2020-12-19	2021-04-02
38	Shaymardanov M.M. (xLiSPirit)¹⁹	176	203	34	425	2792	426.847	528.104	62	2018-05-18	2018-12-20
39	Kalinin K.A. (kalinin_k)¹⁶	150	169	23	355	391	26.197	36.659	60	2012-06-30	2014-11-19
40	Dvoryaninov V. (Valdaj)¹⁶	149	2	23	347	1499	405.517	329.316	55	2013-08-14	2021-01-24
41	Fokin A. (Vizitor )³³	181	261	41	450	2904	60.511	1133.759	52	2019-08-17	2019-09-06
42	Murashkin I.V. (lepton)¹	92	90	21	216	2188	131.332	645.720	51	2012-03-20	2014-03-10
43	Halushka B. (halushka)³³	154	35	20	361	284	131.287	58.407	46	2015-10-19	2016-01-22
44	Titovskij P.S. (kli3ma)²³	165	45	28	396	1903	27.470	17.959	45	2016-06-15	2016-06-15
45	Utyonkov M.N. (=Maxim=)²⁰	172	95	24	385	4533	47.193	11.750	42	2018-10-08	2018-12-11
46	Sysoev A.V. (Sysa)³⁸	119	174	22	254	3225	6162.689	2114.921	39	2016-09-07	2017-11-30
47	Sviridov K.Yu. (orange)¹⁹	121	-16	23	298	1591	62.207	31.081	38	2012-05-17	2012-05-22
48	Senkevich S.V. (GreyC)¹	88	-7	21	219	392	54.541	23.321	38	2009-10-06	2020-12-28
49	Seleznyov A.S. (Artyom S.)¹	85	106	21	211	444	46.358	30.368	38	2009-01-25	2010-09-08
50	Latyntsev N.G. (aks_nsk)⁴⁵	185	174	40	437	2640	35.025	7.501	37	2019-05-21	2021-02-22
51	Vakhrameev A. (WY)³⁴	168	52	25	388	1445	38.991	9.069	36	2015-01-18	2021-02-11
52	Pechatnov V.V. (pvv)¹	116	15	21	275	1992	40.055	15.512	33	2013-04-05	2016-10-29
53	Martynyuk (Wiedzmen)²¹	152	120	23	347	2189	1691.974	1692.363	32	2015-03-10	2016-02-08
54	Nikotin V.M. (@Nikotin)¹	86	4	21	213	235	7.665	3.541	32	2009-04-23	2012-11-08
55	Pyatiletov A. (MontaG)⁵⁴	177	12	39	409	2480	95.242	28.667	30	2019-06-30	2019-06-30
56	Pavlov A.V. (Anton)⁵⁰	176	228	40	412	5011	3237.818	1187.402	29	2019-06-11	2020-11-30
57	Nashyn E. (O.o)²³	123	2	23	287	1159	183.100	77.876	29	2013-09-13	2014-11-28
58	Zin4uk V. (Zin4uk Vadim)³³	142	103	24	338	1334	154.661	42.752	28	2014-06-24	2014-09-02
59	X D. (railgun3r)²⁸	149	104	24	349	1369	320.228	750.766	26	2014-08-16	2015-11-03
60	Mullakhanov R.Kh. (rem)⁹	88	-6	22	213	238	14.311	9.679	26	2009-06-20	2010-02-02
61	F (uff)⁵¹	174	69	31	402	1504	1067.635	952.124	25	2018-01-22	2018-08-20
62	Sivoglazov M.A. (Gaizenberg)⁵¹	155	142	24	353	801	288.636	35.424	24	2015-11-10	2020-08-10
63	Vas'kov E.V. (Johan)²	138	58	24	325	2582	544.101	1034.271	24	2013-08-16	2020-06-11
64	Sukhnev D.A. (mz)²²	129	44	23	306	2468	62.067	13.009	23	2013-05-05	2015-10-17
65	Lyubchenko V.A. (IAS56)⁶	97	84	22	232	1454	647.583	138.580	23	2010-09-14	2014-05-06
66	Anisimov D. (danilko)¹³	91	46	22	212	31	12.449	7.708	23	2009-08-12	2009-08-17
67	Egorov Yu.A. (Yury Egorov)⁴⁴	139	197	23	312	1772	19.754	13.689	21	2016-04-16	2021-03-05
68	Fajnberg M.L. (burnall)³⁶	121	185	23	280	1451	220.153	295.352	21	2013-06-05	2014-11-03
69	Golubin R.S. (Roman Golubin)³	77	4	21	185	1412	92.462	58.691	20	2009-07-01	2018-06-15
70	Komarov A.N. (Shveda Saulya)⁷⁰	144	144	44	384	454	48.503	68.263	19	2021-04-27	2021-04-30
71	Kudryakov A.I. (AKudrakov)¹⁹	96	85	22	227	756	100.367	52.909	18	2010-02-05	2010-05-05
72	Suprun D. (TimonSP)⁴²	152	115	29	372	3033	11.911	1.721	15	2017-01-09	2021-04-01
73	Azbel' E.G. (enull)⁶⁹	142	143	25	347	3439	1146.201	1004.908	15	2018-02-21	2021-01-11
74	Skorohod I. (Dracul4ik)⁶⁵	142	52	25	343	2295	712.625	584.009	15	2017-09-12	2019-09-10
75	Grishin (alvigr)⁵⁵	140	140	24	320	1095	89.625	756.898	15	2014-12-10	2015-01-19
76	Grecha (grecha)⁵³	137	185	24	314	150	8.806	1.612	15	2014-02-26	2016-03-11
77	Frolov (dr.shtopor)⁶⁶	138	148	28	345	705	306.777	49.878	14	2016-04-05	2021-03-17
78	Egorov A.B. (ABEgorov)²⁰	96	140	22	230	750	15.236	8.506	14	2010-02-26	2021-03-02
79	Nikolaenko A.V. (Shadow77)¹²	87	116	22	207	761	66.333	7.673	14	2009-09-13	2019-10-11
80	Soldatenkov Yu.S. (SolYUtor)²	74	-7	21	176	1413	20.060	4.954	14	2010-04-07	2012-11-08
81	Vojnov P.E. (paparome)¹	95	252	23	220	1923	4.431	.562	13	2010-12-01	2019-05-30
82	Belogurova K. (Katy_Ekb)¹	68	1	21	165	550	10.200	3.593	13	2008-11-27	2021-02-10
83	iglbeat (iglbeat)²³	98	75	21	220	1880	31.817	15.741	12	2012-10-19	2012-10-25
84	Proskurin Yu.N. (Xonner)⁷¹	155	95	29	362	2057	51.079	7.973	11	2018-06-23	2020-10-29
85	Maslyaev V.S. (Velmont)⁶¹	157	45	27	361	2168	131.626	42.061	11	2018-02-02	2019-07-02
86	Donskikh A.V. (Ridan)²⁸	98	71	22	226	1511	699.517	31.402	11	2012-05-09	2017-04-28
87	Grishunin M.F. (MikhailFG)⁸⁵	142	40	38	364	765	113.532	3.897	10	2019-01-25	2021-03-24
88	Polyakov S.G. (Ivanoff Alex)³¹	136	135	24	318	1700	186.996	14.537	10	2013-11-29	2020-08-07
89	Kabanets E.G. (azkaban)⁵⁴	147	43	25	336	2227	1921.760	5.246	9	2015-12-30	2015-12-31
90	Bryzgunov V.A. (lorins_)⁶¹	131	153	23	301	1121	183.066	366.226	9	2013-10-23	2017-11-10
91	Bazavluk M. (DoNotLook)⁶⁶	114	2	23	270	3153	695.519	2966.369	9	2019-07-30	2019-07-30
92	Rybkina T.V. (Rybka)³⁷	104	145	22	245	156	107.455	18.281	9	2010-08-30	2020-05-31
93	Makarov I.A. (_Bkmz_)³¹	95	85	22	224	741	7.481	.499	9	2010-03-23	2015-04-04
94	Kurbanoff N.I. (Nariman Kurbanoff)³⁸	88	-14	22	202	798	203.910	141.899	9	2010-07-13	2021-04-29
95	Perfilov B.V. (B o r i s)³³	84	252	22	194	666	923.127	561.220	9	2010-03-31	2018-08-13
96	Milenkov (wqer)⁹³	148	-12	44	379	1768	124.433	13.022	8	2021-03-12	2021-03-17
97	Ilyasov V. (VadimI)⁸⁸	146	148	29	357	251	24.741	.546	8	2017-03-13	2017-04-03
98	Valuev D.I. (Fiolent)¹	102	100	23	246	2714	200.382	69.243	8	2011-02-09	2021-05-16
99	Borisenkov D.V. (xuser)²⁶	105	40	26	241	4309	5.123	.699	8	2019-11-22	2020-12-10
100	Vil'danov M. (mar_vi)²⁹	95	36	21	223	1154	107.374	3.028	8	2011-08-23	2012-11-05

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References

Top 100

Involved in rating: 12945 Involved in second stage rating: 3434

Involved in rating: 12945
Involved in second stage rating: 3434