SQL exercises

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

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