SQL exercises

December 16, 05:04 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	Kreslavskij O.M. (Arcan)	33	37	1784	312
18	Dorodnykh N.A. (nata_doro)	33	37	1957	439
19	Kislitsyn P. (kisslitsyn)	33	37	1984	1553
20	Kurochkin P.A. (qwrqwr)	33	37	2101	2679
21	Petrov Y. (YuriPetrov)	33	37	2120	1106
22	Lyaskovskij V.L. (blr_Oliver)	33	37	2201	1238
23	Avdyushin R. (RusWisely)	33	37	2329	293
24	Pak A. (alexey321)	33	37	2482	2742
25	Chuvstvin M. (chuvstvinmaxim)	33	37	2525	1467
26	Chesnokov S.A. (SergeiCh90)	33	37	2581	889
27	Gavrilov G.A. (potasovka)	33	37	2607	1490
28	Vol'khin S.A. (Sergei Volkhin)	33	37	2662	1051
29	Naumov A.D. (wad881988)	33	37	2717	724
30	Mordvintseva A.E. (ashigray)	33	37	2783	871
31	Dudochkin A. (dandr)	33	37	2885	1256
32	Krasovskij E.A. (pegoopik)	33	37	3093	1257
33	Sereda D.N. (Sereda)	33	37	3125	1693
34	Vinogradova S.M. (Tigra1)	33	37	3133	1048
35	Rodionov S. (oldos)	33	37	3446	7141
36	Blinov R.K. (Blini)	33	37	3625	997
37	Kocherov E.S. (ssense)	33	37	4045	1673
38	Voronkov O.A. (elafonisy)	33	37	4338	985
39	Koptel'tsev V. (selber)	33	37	4652	2166
40	Karasyova N.V. (vlksm)	33	37	4692	2707
41	Komarov A.N. (Shveda Saulya)	33	37	5246	1447
42	Chebykin D. (GriGrim)	33	37	5252	1375
43	Sigankov V.I. (vasilyvanc)	33	37	6037	4109
44	Levina A.V. (Anastasiya_mr)	33	37	6073	5738
45	Ikramov R. (ARNET)	33	37	6178	1610
46	Shkarednyj I.N. (Gosha)	33	37	6343	15929
47	Kostomarov A.V. (al29)	33	37	6368	4129
48	Metalnikov (kirillmet)	33	37	6694	146947
49	Latyntsev N.G. (aks_nsk)	33	37	7421	1248
50	Lyaschenko S.N. (pimen78)	33	37	7636	3367
51	Mityurin V. (mitvol)	33	37	7808	1702
52	Aleksandrov S. (akerman)	33	37	8534	5739
53	Varenikov D.M. (Dmitriy Varenikov)	33	37	9406	3225
54	Chernov D.V. (Kursist)	33	37	9802	2886
55	Mikhailov S. (curiouser)	33	37	9965	6012
56	Sarkis'yan G. (gennadi_s)	33	37	10310	2418
57	Nazarenko I.Yu. (ki.mono)	33	37	10422	2722
58	Avdeenko I. (Igor_001)	33	37	10565	5928
59	Bulyakarov S. (Sa1avat)	33	37	10595	4420
60	Sajfullina E.F. (elena-fairy)	33	37	11321	3225
61	Stepanenko K.Yu. (St.Constantine87)	33	37	11493	3435
62	Ershov I. (qzva)	33	37	11521	4673
63	Kuritsyn V.N. (ValNick)	33	37	12075	6028
64	Maurya (keytime)	33	37	12650	2629
65	Kadomtsev S.I. (z00mz00m1993)	33	37	12668	4287
66	Gapsatarov R.R. (gaspik336)	33	37	13178	4849
67	Polyakov V.M. (rock_4)	33	37	14961	30307
68	Voitovs A. (Lesha.V)	33	37	15644	8689
69	Maksimov I. (igor pupa)	33	37	17738	4495
70	Sazonov A. (an56111)	33	37	17900	7225
71	Ushakov A.K. (andrew_ushakov)	33	37	18869	14348
72	Vdovin S. (Rujan)	33	37	18912	371413
73	Ivanov K.A. (Monsun)	33	37	19652	4175
74	Rudnev V.V. (pazartesi)	33	37	20863	6919
75	Protasov D.E. (preblud)	33	37	21647	6911
76	Yakshin I.V. (ivan_y)	33	37	21700	5693
77	Marchenkov (Decoe)	33	37	22812	7335
78	Belskiy V. (Gambit87)	33	37	24118	60834
79	ASI (asi_sql)	33	37	24149	7302
80	Khokhlov A.V. (rald6839)	33	37	25009	3011
81	Novikov S.V. (@Ser589QA)	33	37	25519	9250
82	Murtazaliev M.G. (Magmur)	33	37	37063	189840
83	Nikitin A.A. (Quaero)	33	37	37919	12974
84	Kulemzin N.E. (Bulochka_c_izumom)	33	37	38224	338493
85	Grigor'yan A.V. (Artyom04)	33	37	39217	29626
86	Gorshkov Yu.V. (yugorshkov)	33	37	40068	32017
87	Strel'bitskij A. (Artem74)	33	37	43111	11637
88	Strel'chenko A.V. (saphirion)	33	37	43136	16373
89	Zhdamorev (zda)	33	37	44149	329438
90	Kir'yanov V.V. (SolidSkills)	33	37	44934	18356
91	Nesutulov K.S. (Htomsik)	33	37	47485	13333
92	Williams B. (BW)	33	37	63232	34330
93	Aver'yanov N.O. (Aveaver23)	33	37	64845	41799
94	Ivanova S. (moonfish)	33	37	70870	276168
95	Kislekov A.M. (Panzerkampfwagen)	33	37	73343	8929
96	Volkov S. (VolkovSA)	33	37	79578	24292
97	Pupkin (Kikimora)	33	37	87342	20116
98	Korneeva E. (Evgenishka)	33	37	95483	95092
99	Yanin M.Yu. (Mikhkha)	33	37	99655	18950
100	Abramova Yu. (GalaxyTears)	33	37	107391	21687

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