SQL exercises

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

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