SQL exercises

February 21, 02:43 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
  • Data simulation (DML);
  • Visual simulation (painting)
  • Exercises voting (SELECT)
  • Exercises voting (DML)

Forums

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

Certification

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

HELP

Query optimization

For employers

Support SQL-EX.RU

Top 100 of the second stage at the
time of solving the exercise #37

No	Person	SolvedEx	LastEx	Minutes	Bad time
1	Suprun D. (TimonSP)	33	37	718	85
2	Timofeeva E.V. (Umrikhina)	33	37	807	84
3	Krasnov A.A. (Nutr1k)	33	37	957	113
4	Nn J. (DAKUCAPORYK)	33	37	977	468
5	Filippkin D.V. (_dimon_)	33	37	985	240
6	Rudikov E. (cubie)	33	37	1183	120
7	Karpov I. (Dompaff)	33	37	1458	1076
8	Evsa I.E. (Igor E)	33	37	1494	984
9	Moskvin P. (Respect)	33	37	1510	648
10	Makarov I.A. (_Bkmz_)	33	37	1586	226
11	Dubinskij A.V. (_velial)	33	37	1590	290
12	Il'in A.N. (ani42)	33	37	1591	904
13	Govorov E. (erxaan)	33	37	1617	2627
14	Lyubomudrov R.G. (born2tilt)	33	37	1649	489
15	Boyarskij V.A. (ChronoMorzh)	33	37	1658	215212
16	Vukolov A. (al.vuk)	33	37	1737	344
17	Safronov P.A. (Paulus73)	33	37	1768	146
18	Kreslavskij O.M. (Arcan)	33	37	1784	312
19	Dorodnykh N.A. (nata_doro)	33	37	1957	439
20	Kislitsyn P. (kisslitsyn)	33	37	1984	1553
21	Kurochkin P.A. (qwrqwr)	33	37	2101	2679
22	Petrov Y. (YuriPetrov)	33	37	2120	1106
23	Lyaskovskij V.L. (blr_Oliver)	33	37	2201	1238
24	Avdyushin R. (RusWisely)	33	37	2329	293
25	Pak A. (alexey321)	33	37	2482	2742
26	Chuvstvin M. (chuvstvinmaxim)	33	37	2525	1467
27	Chesnokov S.A. (SergeiCh90)	33	37	2581	889
28	Gavrilov G.A. (potasovka)	33	37	2607	1490
29	Vol'khin S.A. (Sergei Volkhin)	33	37	2662	1051
30	Naumov A.D. (wad881988)	33	37	2717	724
31	Mordvintseva A.E. (ashigray)	33	37	2783	871
32	Dudochkin A. (dandr)	33	37	2885	1256
33	Krasovskij E.A. (pegoopik)	33	37	3093	1257
34	Sereda D.N. (Sereda)	33	37	3125	1693
35	Vinogradova S.M. (Tigra1)	33	37	3133	1048
36	Rodionov S. (oldos)	33	37	3446	7141
37	Blinov R.K. (Blini)	33	37	3625	997
38	Tkachenko D. (_GUERNIKA_)	33	37	3844	2898
39	Kocherov E.S. (ssense)	33	37	4045	1673
40	Voronkov O.A. (elafonisy)	33	37	4338	985
41	Koptel'tsev V. (selber)	33	37	4652	2166
42	Karasyova N.V. (vlksm)	33	37	4692	2707
43	Komarov A.N. (Shveda Saulya)	33	37	5246	1447
44	Chebykin D. (GriGrim)	33	37	5252	1375
45	Sigankov V.I. (vasilyvanc)	33	37	6037	4109
46	Levina A.V. (Anastasiya_mr)	33	37	6073	5738
47	Ikramov R. (ARNET)	33	37	6178	1610
48	Shkarednyj I.N. (Gosha)	33	37	6343	15929
49	Kostomarov A.V. (al29)	33	37	6368	4129
50	Metalnikov (kirillmet)	33	37	6694	146947
51	Latyntsev N.G. (aks_nsk)	33	37	7421	1248
52	Lyaschenko S.N. (pimen78)	33	37	7636	3367
53	Mityurin V. (mitvol)	33	37	7808	1702
54	Aleksandrov S. (akerman)	33	37	8534	5739
55	Varenikov D.M. (Dmitriy Varenikov)	33	37	9406	3225
56	Chernov D.V. (Kursist)	33	37	9802	2886
57	Mikhailov S. (curiouser)	33	37	9965	6012
58	Sarkis'yan G. (gennadi_s)	33	37	10310	2418
59	Nazarenko I.Yu. (ki.mono)	33	37	10422	2722
60	Avdeenko I. (Igor_001)	33	37	10565	5928
61	Bulyakarov S. (Sa1avat)	33	37	10595	4420
62	Sajfullina E.F. (elena-fairy)	33	37	11321	3225
63	Stepanenko K.Yu. (St.Constantine87)	33	37	11493	3435
64	Ershov I. (qzva)	33	37	11521	4673
65	Kuritsyn V.N. (ValNick)	33	37	12075	6028
66	Maurya (keytime)	33	37	12650	2629
67	Kadomtsev S.I. (z00mz00m1993)	33	37	12668	4287
68	Gapsatarov R.R. (gaspik336)	33	37	13178	4849
69	Polyakov V.M. (rock_4)	33	37	14961	30307
70	Voitovs A. (Lesha.V)	33	37	15644	8689
71	fioletovaya (fioletovaya2)	33	37	15814	6774
72	Maksimov I. (igor pupa)	33	37	17738	4495
73	Sazonov A. (an56111)	33	37	17900	7225
74	Ushakov A.K. (andrew_ushakov)	33	37	18869	14348
75	Vdovin S. (Rujan)	33	37	18912	371413
76	Ivanov K.A. (Monsun)	33	37	19652	4175
77	P I.*. (IrinaPetr)	33	37	19948	10675
78	Rudnev V.V. (pazartesi)	33	37	20863	6919
79	Protasov D.E. (preblud)	33	37	21647	6911
80	Yakshin I.V. (ivan_y)	33	37	21700	5693
81	Marchenkov (Decoe)	33	37	22812	7335
82	Belskiy V. (Gambit87)	33	37	24118	60834
83	ASI (asi_sql)	33	37	24149	7302
84	Khokhlov A.V. (rald6839)	33	37	25009	3011
85	Novikov S.V. (@Ser589QA)	33	37	25519	9250
86	Murtazaliev M.G. (Magmur)	33	37	37063	189840
87	Nikitin A.A. (Quaero)	33	37	37919	12974
88	Kulemzin N.E. (Bulochka_c_izumom)	33	37	38224	338493
89	Grigor'yan A.V. (Artyom04)	33	37	39217	29626
90	Gorshkov Yu.V. (yugorshkov)	33	37	40068	32017
91	Strel'bitskij A. (Artem74)	33	37	43111	11637
92	Strel'chenko A.V. (saphirion)	33	37	43136	16373
93	Zhdamorev (zda)	33	37	44149	329438
94	Kir'yanov V.V. (SolidSkills)	33	37	44934	18356
95	Nesutulov K.S. (Htomsik)	33	37	47485	13333
96	Williams B. (BW)	33	37	63232	34330
97	Aver'yanov N.O. (Aveaver23)	33	37	64845	41799
98	Ivanova S. (moonfish)	33	37	70870	276168
99	Kislekov A.M. (Panzerkampfwagen)	33	37	73343	8929
100	Volkov S. (VolkovSA)	33	37	79578	24292

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References

Top 100 of the second stage at the time of solving the exercise #37

Top 100 of the second stage at the
time of solving the exercise #37