TOP 100 at "SQL Exercises"

June 24, 04:51 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

  • SELECT (learning stage)
  • SELECT (learning stage,
      choosing DBMS)
  • SELECT (rating stages)
  • DML 
  • Transact-SQL tests
  • Modelling of data
  • Visual modelling (painting)
  • Exercises voting

Forums

  • Learning stage
  • Rating stages
  • Favorites
  • Search

Certification

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

HELP

Query optimization

For employers

Support SQL-EX.RU

Обследование зданий
Узнайте больше про тепловизионное обследование зданий и сооружений сейчас
мегаполис-центр.рф
Шина автомобильная Winrun KF997 R22 305/45 118V: шины r22 5 .
moscow.petromaster.ru
Дизайн криотерапия здесь
lantanclinic.ru

Top 100	Candidates How the rating position is calculated
Involved in rating: 11978 Involved in second stage rating: 3080

No	Person	Number of Sel_ex	Last_Sel	Number of DML_ex	Scores	Days	Days_2	Days_3	S_3	LastSolved	LastVisit
1	Krasovskij E.A. (pegoopik)¹	264	227	34	649	2851	210.254	14.124	240	2018-04-28	2018-06-22
2	Kostomarov A.V. (al29)¹	252	95	31	624	2214	4128.341	2266.898	240	2018-05-18	2018-06-19
3	Kreslavskij O.M. (Arcan)¹	263	229	34	646	4090	273.280	214.614	237	2018-04-14	2018-06-23
4	Boiko D. (Angellore)¹	263	228	33	645	3846	5236.407	3825.140	237	2018-02-20	2018-03-23
5	Bezhaev A.Yu. (Baser)¹	262	227	34	643	2924	201.513	178.821	234	2018-05-04	2018-05-06
6	Dubinskij A.V. (_velial)¹	259	307	34	637	3093	2797.393	3371.376	228	2018-05-03	2018-06-23
7	Karasyova N.V. (vlksm)¹	259	225	34	633	4354	290.336	241.682	224	2018-04-15	2018-06-19
8	Kurochkin P.A. (qwrqwr)¹	255	223	34	621	3078	255.904	164.392	212	2018-04-15	2018-06-23
9	Doschenko V.N. (mcrain)⁹	232	152	34	576	2452	1984.495	469.672	207	2018-06-19	2018-06-23
10	Vyazovetskov A.S. (alex_v)⁹	240	161	23	563	4361	177.452	94.196	205	2018-05-17	2018-05-17
11	Filippkin D.V. (_dimon_)¹	244	115	29	597	2737	194.554	127.909	202	2016-07-20	2016-09-29
12	Movlyanov A.P. (Oct)⁷	244	10	29	588	1307	2353.723	2448.847	193	2017-01-23	2017-04-03
13	Sal'nikov S.A. ($erges)¹	227	206	25	551	2533	17.505	14.498	181	2015-02-02	2018-01-23
14	Kukushkin S.A. (smog)⁹	225	163	29	527	2368	1054.562	1122.181	153	2017-10-03	2018-05-11
15	Yatsuk A.A. (Faust_zp)¹	186	255	24	459	1984	144.150	108.840	137	2012-07-12	2012-07-30
16	Kuznetsov V.S. (herrRo)¹	171	260	23	418	1167	478.511	73.335	122	2012-02-08	2013-06-18
17	Grinkevich D.L. (Dmitrij Grinkevich)¹³	204	10	27	467	2059	367.128	932.343	109	2017-05-31	2018-05-22
18	Drozdkov A.N. (anddros)⁵	192	16	24	445	2244	12.341	11.091	108	2014-07-21	2015-01-29
19	Zajtsev V.S. (Sleeping)¹⁹	209	184	27	460	3601	1040.053	1327.686	99	2018-04-17	2018-04-19
20	Shindin A.V. (AlShin)¹	147	252	23	366	928	408.505	777.457	99	2011-05-05	2014-05-18
21	Timofeeva E.V. (Umrikhina)¹	207	95	34	486	3652	50.506	47.237	96	2018-04-24	2018-06-01
22	Aliev R. (y4nzi)²¹	212	187	33	489	236	64.714	37.753	95	2018-01-25	2018-05-28
23	Tarasov D.B. (Gavrila)⁹	164	15	23	393	2427	151.343	99.710	95	2012-04-23	2018-01-08
24	Varenikov D.M. (Dmitriy Varenikov)²¹	206	69	34	472	2754	2064.206	1200.260	93	2018-05-11	2018-06-06
25	Orlov M.V. (Eagleoff)⁹	151	258	23	369	952	138.468	106.466	92	2011-11-10	2018-05-22
26	Zotov P.G. (Ozzy)¹	149	-16	23	366	1412	213.524	187.364	83	2012-02-05	2016-08-18
27	Derzhal'tsev V.A. (MadVet)³	137	100	22	338	2073	143.349	99.698	81	2010-12-29	2015-10-14
28	Chernov D.V. (Kursist)²⁸	195	158	34	446	593	602.215	560.972	70	2018-06-20	2018-06-23
29	Agapov V. (KERBEROS)¹	161	253	24	386	2409	35.562	27.703	69	2013-04-02	2016-09-24
30	Petrov Y. (YuriPetrov)²¹	195	304	31	439	2360	63.175	24.005	64	2017-08-02	2017-10-25
31	Chebykin D.N. (GriGrim)²⁵	202	69	33	461	3199	815.957	380.694	62	2018-03-19	2018-05-03
32	Shaymardanov M.M. (xLiSPirit)¹⁹	180	203	34	430	2792	426.854	528.104	62	2018-05-18	2018-06-22
33	Kalinin K.A. (kalinin_k)¹⁶	154	169	23	360	391	26.206	36.659	60	2012-06-30	2014-11-19
34	Fedevych V.I. (labuch_fedev)³³	191	183	33	435	1394	860.430	1551.871	57	2017-12-23	2018-01-08
35	Williams B. (BW)³³	197	156	34	444	3382	3819.592	1531.342	56	2018-06-11	2018-06-20
36	Dvoryaninov V. (Valdaj)¹⁶	153	7	23	352	1499	405.533	329.316	55	2013-08-14	2018-05-04
37	Murashkin I.V. (lepton)¹	95	90	21	220	2188	131.386	645.720	51	2012-03-20	2014-03-10
38	Fokin A. (Vizitor )³³	176	35	27	416	1569	53.842	1127.337	46	2015-12-21	2016-05-11
39	Halushka B. (halushka)³³	159	35	20	366	284	131.302	58.407	46	2015-10-19	2016-01-22
40	Titovskij P.S. (kli3ma)²³	169	45	28	401	1903	27.479	17.959	45	2016-06-15	2016-06-15
41	Shkarednyj I.N. (Gosha)⁴¹	173	152	34	416	4491	655.548	47.259	42	2018-05-14	2018-06-04
42	Utyonkov M.N. (=Maxim=)²⁰	169	77	24	377	3406	48.605	11.750	42	2015-09-07	2015-10-28
43	Sysoev A.V. (Sysa)³⁸	123	174	22	259	3225	6163.368	2114.921	39	2016-09-07	2017-11-30
44	Sviridov K.Yu. (orange)¹⁹	125	-16	23	303	1591	62.221	31.081	38	2012-05-17	2012-05-22
45	Senkevich S.V. (GreyC)¹	91	2	21	223	393	55.287	23.321	38	2009-10-07	2014-03-15
46	Seleznyov A.S. (Artyom S.)¹	87	106	21	214	444	46.448	30.368	38	2009-01-25	2010-09-08
47	Koptel'tsev V. (selber)⁴⁷	187	152	34	432	2117	1063.047	181.263	37	2018-06-08	2018-06-23
48	Vakhrameev A. (WY)³⁴	173	52	25	393	1445	39.011	9.069	36	2015-01-18	2018-02-11
49	Latyntsev N.G. (aks_nsk)⁴⁵	184	177	34	424	2280	28.004	5.220	34	2018-05-26	2018-06-22
50	Pechatnov V.V. (pvv)¹	120	15	21	280	1992	40.086	15.512	33	2013-04-05	2016-10-29
51	Martynyuk (Wiedzmen)²¹	156	120	23	352	2189	1691.989	1692.363	32	2015-03-10	2016-02-08
52	Nikotin V.M. (@Nikotin)¹	89	2	21	217	467	7.697	3.541	32	2009-12-11	2012-11-08
53	Nashyn E. (O.o)²³	127	7	23	292	1159	183.142	77.876	29	2013-09-13	2014-11-28
54	Zin4uk V. (Zin4uk Vadim)³³	146	103	24	343	1334	154.722	42.752	28	2014-06-24	2014-09-02
55	F (uff)⁵¹	179	69	31	408	1504	1073.788	952.124	26	2018-01-22	2018-01-26
56	Pavlov A.V. (Anton)⁵⁰	173	-17	34	398	4635	2081.319	31.027	26	2018-05-31	2018-06-02
57	X D. (railgun3r)²⁸	153	104	24	354	1369	320.237	750.766	26	2014-08-16	2015-11-03
58	Mullakhanov R.Kh. (rem)⁹	90	-6	22	216	238	14.329	9.679	26	2009-06-20	2010-02-02
59	Sivoglazov M.A. (Gaizenberg)⁵¹	159	142	24	358	801	288.645	35.424	24	2015-11-10	2017-07-17
60	Vas'kov E.V. (Johan)²	142	58	24	330	2582	544.122	1034.271	24	2013-08-16	2014-01-03
61	Sukhnev D.A. (mz)²²	133	44	23	311	2468	62.106	13.009	23	2013-05-05	2015-10-17
62	Lyubchenko V.A. (IAS56)⁶	100	84	22	236	1454	649.209	138.580	23	2010-09-14	2014-05-06
63	Anisimov D. (danilko)¹³	94	46	22	216	31	12.467	7.708	23	2009-08-12	2009-08-17
64	Pyatiletov A. (MontaG)⁶⁰	175	140	34	396	2094	80.771	14.223	22	2018-06-09	2018-06-09
65	Egorov Yu.A. (Yury Egorov)⁴⁴	143	197	23	317	1772	19.759	13.689	21	2016-04-16	2016-04-16
66	Fajnberg M.L. (burnall)³⁶	125	185	23	285	1451	220.161	295.352	21	2013-06-05	2014-11-03
67	Golubin R.S. (Roman Golubin)³	80	2	21	189	1714	92.685	58.691	20	2010-04-29	2018-06-15
68	Kudryakov A.I. (AKudrakov)¹⁹	99	85	22	231	756	101.131	52.909	18	2010-02-05	2010-05-05
69	Sigankov V.I. (vasilyvanc)⁶⁹	172	303	34	397	1538	94.841	14.490	17	2018-05-03	2018-06-23
70	Suprun D. (TimonSP)⁴²	156	115	29	377	3033	11.926	1.721	15	2017-01-09	2018-04-01
71	Azbel' E.G. (enull)⁶⁹	146	143	25	352	3439	1146.218	1004.908	15	2018-02-21	2018-06-22
72	Skorohod I. (Dracul4ik)⁶⁵	146	52	25	348	2297	712.643	584.009	15	2017-09-12	2017-09-15
73	Grishin (alvigr)⁵⁵	144	140	24	325	1095	89.639	756.898	15	2014-12-10	2015-01-19
74	Grecha (grecha)⁵³	141	185	24	319	151	8.813	1.612	15	2014-02-26	2016-03-11
75	Frolov (dr.shtopor)⁶⁶	142	148	28	350	707	306.798	49.878	14	2016-04-05	2016-04-10
76	Egorov A.B. (ABEgorov)²⁰	99	140	22	234	750	15.262	8.506	14	2010-02-26	2011-05-17
77	Nikolaenko A.V. (Shadow77)¹²	90	116	22	211	761	66.350	7.673	14	2009-09-13	2010-03-24
78	Soldatenkov Yu.S. (SolYUtor)²	76	-7	21	179	1413	21.067	4.954	14	2010-04-07	2012-11-08
79	Vojnov P.E. (paparome)¹	98	252	23	224	1923	4.448	.562	13	2010-12-01	2011-04-21
80	Belogurova K. (Katy_Ekb)¹	70	1	21	168	550	10.225	3.593	13	2008-11-27	2015-03-20
81	iglbeat (iglbeat)²³	102	75	21	225	1880	37.093	15.741	12	2012-10-19	2012-10-25
82	Proskurin Yu.N. (Xonner)⁷¹	159	95	29	367	2057	51.178	7.973	11	2018-06-23	2018-06-23
83	Maslyaev V.S. (Velmont)⁶¹	162	45	27	366	2168	131.640	42.061	11	2018-02-02	2018-02-09
84	Donskikh A.V. (Ridan)²⁸	101	71	22	230	1511	699.561	31.402	11	2012-05-09	2017-04-28
85	Grishunin M.F. (MikhailFG)⁸⁵	145	142	34	361	521	113.290	3.897	10	2018-05-25	2018-05-26
86	Polyakov S.G. (Ivanoff Alex)³¹	140	135	24	323	1700	187.082	14.537	10	2013-11-29	2018-06-08
87	Kabanets E.G. (azkaban)⁵⁴	152	43	25	341	2227	1921.772	5.246	9	2015-12-30	2015-12-31
88	Bryzgunov V.A. (lorins_)⁶¹	135	153	23	306	1121	183.078	366.226	9	2013-10-23	2017-11-10
89	Rybkina T.V. (Rybka)³⁷	107	145	22	249	156	107.472	18.281	9	2010-08-30	2017-06-27
90	Makarov I.A. (_Bkmz_)³¹	98	85	22	228	741	7.517	.499	9	2010-03-23	2015-04-04
91	Kurbanoff N.I. (Nariman Kurbanoff)³⁸	91	-14	22	206	798	204.959	141.899	9	2010-07-13	2018-05-21
92	Perfilov B.V. (B o r i s)³³	87	252	22	198	666	923.158	561.220	9	2010-03-31	2017-09-13
93	Ilyasov V. (VadimI)⁸⁸	150	148	29	362	251	24.746	.546	8	2017-03-13	2017-04-03
94	Valuev D.I. (Fiolent)¹	105	100	23	250	2714	201.205	69.243	8	2011-02-09	2018-03-14
95	Borisenkov D.V. (xuser)²⁶	107	35	26	244	3514	5.074	.699	8	2017-09-18	2018-03-22
96	Vil'danov M. (mar_vi)²⁹	98	36	21	227	1154	107.382	3.028	8	2011-08-23	2012-11-05
97	Glazyrin D.S. (glassman)²⁴	98	-16	22	226	1731	445.793	.420	8	2013-03-14	2018-01-22
98	Mishin S.A. (CepbIu)²⁷	72	96	21	170	294	9.468	1.708	8	2009-02-12	2009-02-16
99	Bulanov P.A. (rage)³⁶	73	54	21	170	105	3.012	1.944	8	2008-10-29	2008-10-29
100	Kuvalkin K.S. (Cyrilus)¹	69	54	21	162	1434	12.526	2.380	8	2008-11-04	2017-05-24

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References

Top 100

Involved in rating: 11978 Involved in second stage rating: 3080

Involved in rating: 11978
Involved in second stage rating: 3080