TOP 100 at "SQL Exercises"

August 15, 03:56 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: 12038 Involved in second stage rating: 3097

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)¹	265	230	36	654	2946	210.254	14.124	241	2018-08-01	2018-08-14
2	Kostomarov A.V. (al29)¹	252	95	34	627	2262	4128.341	2266.898	239	2018-07-05	2018-08-14
3	Doschenko V.N. (mcrain)³	246	165	36	610	2504	2022.172	507.349	237	2018-08-10	2018-08-14
4	Kreslavskij O.M. (Arcan)¹	263	229	36	649	4195	273.280	214.614	236	2018-07-28	2018-08-14
5	Boiko D. (Angellore)¹	263	228	33	644	3846	5236.407	3825.140	236	2018-02-20	2018-03-23
6	Bezhaev A.Yu. (Baser)¹	262	227	34	642	2924	201.513	178.821	233	2018-05-04	2018-07-06
7	Dubinskij A.V. (_velial)¹	259	307	36	640	3180	2797.393	3371.376	227	2018-07-29	2018-08-14
8	Karasyova N.V. (vlksm)¹	259	225	34	632	4354	290.336	241.682	223	2018-04-15	2018-08-07
9	Kurochkin P.A. (qwrqwr)¹	255	223	36	624	3182	255.904	164.392	211	2018-07-28	2018-08-02
10	Vyazovetskov A.S. (alex_v)⁹	240	161	23	562	4361	177.452	94.196	204	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-07-12
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-08-07
18	Drozdkov A.N. (anddros)⁵	192	16	24	445	2244	12.341	11.091	108	2014-07-21	2015-01-29
19	Shindin A.V. (AlShin)¹	147	252	23	366	928	408.505	777.457	99	2011-05-05	2014-05-18
20	Zajtsev V.S. (Sleeping)¹⁹	209	184	27	459	3601	1040.053	1327.686	98	2018-04-17	2018-04-19
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-08-10
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	36	476	2832	2064.206	1200.260	93	2018-07-28	2018-08-13
25	Chernov D.V. (Kursist)²⁵	205	207	36	474	646	648.380	607.063	92	2018-08-12	2018-08-14
26	Orlov M.V. (Eagleoff)⁹	151	258	23	369	952	138.468	106.466	92	2011-11-10	2018-05-22
27	Zotov P.G. (Ozzy)¹	149	-16	23	366	1412	213.524	187.364	83	2012-02-05	2016-08-18
28	Derzhal'tsev V.A. (MadVet)³	137	100	22	338	2073	143.349	99.698	81	2010-12-29	2015-10-14
29	Agapov V. (KERBEROS)¹	161	253	24	386	2409	35.562	27.703	69	2013-04-02	2016-09-24
30	Petrov Y. (YuriPetrov)²¹	196	95	36	448	2736	63.209	24.005	64	2018-08-13	2018-08-14
31	Chebykin D.N. (GriGrim)²⁵	202	69	33	461	3199	815.957	380.694	62	2018-03-19	2018-07-14
32	Shaymardanov M.M. (xLiSPirit)¹⁹	180	203	34	430	2792	426.854	528.104	62	2018-05-18	2018-07-05
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-08-06
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	2018-08-05
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	36	420	4568	655.548	47.259	42	2018-07-30	2018-08-14
42	Utyonkov M.N. (=Maxim=)²⁰	169	77	24	377	3406	48.605	11.750	42	2015-09-07	2015-10-28
43	Koptel'tsev V. (selber)⁴³	188	230	36	438	2169	1063.352	181.568	39	2018-07-30	2018-08-14
44	Sysoev A.V. (Sysa)³⁸	123	174	22	259	3225	6163.368	2114.921	39	2016-09-07	2017-11-30
45	Sviridov K.Yu. (orange)¹⁹	125	-16	23	303	1591	62.221	31.081	38	2012-05-17	2012-05-22
46	Senkevich S.V. (GreyC)¹	91	2	21	223	393	55.287	23.321	38	2009-10-07	2014-03-15
47	Seleznyov A.S. (Artyom S.)¹	87	106	21	214	444	46.448	30.368	38	2009-01-25	2010-09-08
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-07-24
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	Pavlov A.V. (Anton)⁵⁰	173	-17	34	398	4635	2081.319	31.027	26	2018-05-31	2018-06-02
56	X D. (railgun3r)²⁸	153	104	24	354	1369	320.237	750.766	26	2014-08-16	2015-11-03
57	Mullakhanov R.Kh. (rem)⁹	90	-6	22	216	238	14.329	9.679	26	2009-06-20	2010-02-02
58	F (uff)⁵¹	179	69	31	407	1504	1073.788	952.124	25	2018-01-22	2018-07-20
59	Pyatiletov A. (MontaG)⁵⁹	176	168	35	400	2138	80.955	14.407	24	2018-07-23	2018-08-13
60	Sivoglazov M.A. (Gaizenberg)⁵¹	159	142	24	358	801	288.645	35.424	24	2015-11-10	2017-07-17
61	Vas'kov E.V. (Johan)²	142	58	24	330	2582	544.122	1034.271	24	2013-08-16	2014-01-03
62	Sukhnev D.A. (mz)²²	133	44	23	311	2468	62.106	13.009	23	2013-05-05	2015-10-17
63	Lyubchenko V.A. (IAS56)⁶	100	84	22	236	1454	649.209	138.580	23	2010-09-14	2014-05-06
64	Anisimov D. (danilko)¹³	94	46	22	216	31	12.467	7.708	23	2009-08-12	2009-08-17
65	Sigankov V.I. (vasilyvanc)⁶⁵	173	141	36	405	1624	97.185	16.833	21	2018-07-28	2018-08-15
66	Egorov Yu.A. (Yury Egorov)⁴⁴	143	197	23	317	1772	19.759	13.689	21	2016-04-16	2016-04-16
67	Fajnberg M.L. (burnall)³⁶	125	185	23	285	1451	220.161	295.352	21	2013-06-05	2014-11-03
68	Golubin R.S. (Roman Golubin)³	80	2	21	189	1714	92.685	58.691	20	2010-04-29	2018-06-15
69	Kudryakov A.I. (AKudrakov)¹⁹	99	85	22	231	756	101.131	52.909	18	2010-02-05	2010-05-05
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-07-20
72	Skorohod I. (Dracul4ik)⁶⁵	146	52	25	348	2297	712.643	584.009	15	2017-09-12	2018-08-07
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-08-14
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	36	365	592	113.290	3.897	10	2018-08-04	2018-08-04
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	2018-08-13
93	Ilyasov V. (VadimI)⁸⁸	150	148	29	362	251	24.746	.546	8	2017-03-13	2017-04-03
94	Milenkov (wqer)⁹⁴	143	148	35	360	821	120.594	13.022	8	2018-08-08	2018-08-14
95	Valuev D.I. (Fiolent)¹	105	100	23	250	2714	201.205	69.243	8	2011-02-09	2018-07-22
96	Borisenkov D.V. (xuser)²⁶	107	35	26	244	3514	5.074	.699	8	2017-09-18	2018-03-22
97	Vil'danov M. (mar_vi)²⁹	98	36	21	227	1154	107.382	3.028	8	2011-08-23	2012-11-05
98	Glazyrin D.S. (glassman)²⁴	98	-16	22	226	1731	445.793	.420	8	2013-03-14	2018-01-22
99	Mishin S.A. (CepbIu)²⁷	72	96	21	170	294	9.468	1.708	8	2009-02-12	2009-02-16
100	Bulanov P.A. (rage)³⁶	73	54	21	170	105	3.012	1.944	8	2008-10-29	2008-10-29

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References

Top 100

Involved in rating: 12038 Involved in second stage rating: 3097

Involved in rating: 12038
Involved in second stage rating: 3097