SQL exercises

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

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