SQL exercises

May 24, 17:53 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	Filippkin D.V. (_dimon_)	34	37	992	240
3	Makarov I.A. (_Bkmz_)	34	37	1603	226
4	Boyarskij V.A. (ChronoMorzh)	34	37	1671	215212
5	Vyazovetskov A.S. (alex_v)	34	37	1725	153
6	Safronov P.A. (Paulus73)	34	37	1794	146
7	Gusev A.O. (NowOrNever)	34	37	1952	240
8	Kurochkin P.A. (qwrqwr)	34	37	2161	2679
9	Krasovskij E.A. (pegoopik)	34	37	3093	1257
10	Vinogradova S.M. (Tigra1)	34	37	3154	1048
11	Vasev A.V. (Vasev_Aleksey)	34	37	4341	2422
12	Koptel'tsev V. (selber)	34	37	4673	2166
13	Karasyova N.V. (vlksm)	34	37	4726	2707
14	Komarov A.N. (Shveda Saulya)	34	37	5263	1447
15	M (DanilM2304)	34	37	6030	1761
16	Sigankov V.I. (vasilyvanc)	34	37	6056	4109
17	Kostomarov A.V. (al29)	34	37	6431	4129
18	Gorbunov M.S. (gms)	34	37	7052	1299
19	Odnokurtsev (AlFochino)	34	37	8303	88137
20	Varenikov D.M. (Dmitriy Varenikov)	34	37	9426	3225
21	Chernov D.V. (Kursist)	34	37	9847	2886
22	Sarkis'yan G. (gennadi_s)	34	37	10323	2418
23	Kolesnikov S.O. (bulbasaurus)	34	37	10840	4420
24	Stepanenko K.Yu. (St.Constantine87)	34	37	11550	3435
25	Kuritsyn V.N. (ValNick)	34	37	12102	6028
26	Ershov I. (qzva)	34	37	13313	4673
27	Polyakov V.M. (rock_4)	34	37	15002	30307
28	fioletovaya (fioletovaya2)	34	37	15838	6774
29	Gapanovich P.A. (drestar1)	34	37	16025	3888
30	Nesov V.A. (80STH)	34	37	18490	934525
31	Vdovin S. (Rujan)	34	37	18969	371413
32	P I.*. (IrinaPetr)	34	37	20004	10675
33	ASI (asi_sql)	34	37	24340	7302
34	Kislekov A.M. (Panzerkampfwagen)	34	37	73483	8929
35	Abramova Yu. (GalaxyTears)	34	37	129049	21687
36	Zubov D.Z. (Dmitrij84)	34	37	928478	1491942
37	Kanapelka (silvr)	34	37	990406	3690574
38	Suprun D. (TimonSP)	33	37	718	85
39	Timofeeva E.V. (Umrikhina)	33	37	807	84
40	Krasnov A.A. (Nutr1k)	33	37	957	113
41	Nn J. (DAKUCAPORYK)	33	37	977	468
42	Rudikov E. (cubie)	33	37	1183	120
43	Karpov I. (Dompaff)	33	37	1458	1076
44	Evsa I.E. (Igor E)	33	37	1494	984
45	Moskvin P. (Respect)	33	37	1510	648
46	Dubinskij A.V. (_velial)	33	37	1590	290
47	Il'in A.N. (ani42)	33	37	1591	904
48	Govorov E. (erxaan)	33	37	1617	2627
49	Lyubomudrov R.G. (born2tilt)	33	37	1649	489
50	Vukolov A. (al.vuk)	33	37	1737	344
51	Kreslavskij O.M. (Arcan)	33	37	1784	312
52	Dorodnykh N.A. (nata_doro)	33	37	1957	439
53	Kislitsyn P. (kisslitsyn)	33	37	1984	1553
54	Petrov Y. (YuriPetrov)	33	37	2120	1106
55	Lyaskovskij V.L. (blr_Oliver)	33	37	2201	1238
56	Avdyushin R. (RusWisely)	33	37	2329	293
57	Pak A. (alexey321)	33	37	2482	2742
58	Chuvstvin M. (chuvstvinmaxim)	33	37	2525	1467
59	Chesnokov S.A. (SergeiCh90)	33	37	2581	889
60	Gavrilov G.A. (potasovka)	33	37	2607	1490
61	Vol'khin S.A. (Sergei Volkhin)	33	37	2662	1051
62	Naumov A.D. (wad881988)	33	37	2717	724
63	Mordvintseva A.E. (ashigray)	33	37	2783	871
64	Dudochkin A. (dandr)	33	37	2885	1256
65	Sereda D.N. (Sereda)	33	37	3125	1693
66	Rodionov S. (oldos)	33	37	3446	7141
67	Blinov R.K. (Blini)	33	37	3625	997
68	Tkachenko D. (_GUERNIKA_)	33	37	3844	2898
69	Kocherov E.S. (ssense)	33	37	4045	1673
70	Voronkov O.A. (elafonisy)	33	37	4338	985
71	Chebykin D. (GriGrim)	33	37	5252	1375
72	Levina A.V. (Anastasiya_mr)	33	37	6073	5738
73	Ikramov R. (ARNET)	33	37	6178	1610
74	Shkarednyj I.N. (Gosha)	33	37	6343	15929
75	Metalnikov (kirillmet)	33	37	6694	146947
76	Latyntsev N.G. (aks_nsk)	33	37	7421	1248
77	Lyaschenko S.N. (pimen78)	33	37	7636	3367
78	Mityurin V. (mitvol)	33	37	7808	1702
79	Aleksandrov S. (akerman)	33	37	8534	5739
80	Gonohov M.S. (Mixus)	33	37	8682	1587
81	Kad V.Y. (s108)	33	37	9571	8442
82	Mikhailov S. (curiouser)	33	37	9965	6012
83	Nazarenko I.Yu. (ki.mono)	33	37	10422	2722
84	Avdeenko I. (Igor_001)	33	37	10565	5928
85	Bulyakarov S. (Sa1avat)	33	37	10595	4420
86	Sajfullina E.F. (elena-fairy)	33	37	11321	3225
87	Maurya (keytime)	33	37	12650	2629
88	Kadomtsev S.I. (z00mz00m1993)	33	37	12668	4287
89	Gapsatarov R.R. (gaspik336)	33	37	13178	4849
90	Voitovs A. (Lesha.V)	33	37	15644	8689
91	Maksimov I. (igor pupa)	33	37	17738	4495
92	Sazonov A. (an56111)	33	37	17900	7225
93	Ushakov A.K. (andrew_ushakov)	33	37	18869	14348
94	Ivanov K.A. (Monsun)	33	37	19652	4175
95	Rudnev V.V. (pazartesi)	33	37	20863	6919
96	Protasov D.E. (preblud)	33	37	21647	6911
97	Yakshin I.V. (ivan_y)	33	37	21700	5693
98	Marchenkov (Decoe)	33	37	22812	7335
99	Belskiy V. (Gambit87)	33	37	24118	60834
100	Khokhlov A.V. (rald6839)	33	37	25009	3011

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