SQL exercises

April 07, 07:23 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 #5

No	Person	SolvedEx	LastEx	Minutes	Bad time
1	Myachin I.M. (getred)	2	5	2	45996
2	Govorov E. (erxaan)	2	5	8	11
3	Gonohov M.S. (Mixus)	2	5	9	1587
4	Nn J. (DAKUCAPORYK)	2	5	10	112
5	Krasnov A.A. (Nutr1k)	2	5	10	51
6	Vol'khin S.A. (Sergei Volkhin)	2	5	11	406
7	Lysenko O. (Oleg15062025)	2	5	14	354
8	Zolotyh (Guy)	2	5	15	18
9	Koptel'tsev V. (selber)	2	5	15	28
10	Boyarskij V.A. (ChronoMorzh)	2	5	16	66
11	Kajkova I.V. (ira_kay)	2	5	16	1404
12	gls (gls52)	2	5	17	70
13	Krasovskij E.A. (pegoopik)	2	5	18	78
14	Suprun D. (TimonSP)	2	5	19	31
15	Tsarapkin D.I. (Tsarapkin)	2	5	19	44
16	Markov A. (Sasha Markov)	2	5	21	631
17	Kreslavskij O.M. (Arcan)	2	5	22	50
18	Dubinskij A.V. (_velial)	2	5	22	34
19	Karpov I. (Dompaff)	2	5	22	73
20	- (wublubbadubdub)	2	5	23	4697
21	Shkarednyj I.N. (Gosha)	2	5	24	485
22	Mityurin V. (mitvol)	2	5	25	40
23	Lyaskovskij V.L. (blr_Oliver)	2	5	25	33
24	Badakh'yan S. (wamp.j)	2	5	25	60
25	Filippkin D.V. (_dimon_)	2	5	26	33
26	Zhitchenko A.I. (ArrenHawk)	2	5	26	50
27	Ushakov A.K. (andrew_ushakov)	2	5	26	83
28	Gusev A.O. (NowOrNever)	2	5	26	49
29	Bezhaev A.Yu. (Baser)	2	5	27	170
30	Pak A. (alexey321)	2	5	27	56
31	Gavrilov G.A. (potasovka)	2	5	28	195
32	Chesnokov S.A. (SergeiCh90)	2	5	28	88
33	Tarshin S.N. (tsn)	2	5	29	92
34	Dorodnykh N.A. (nata_doro)	2	5	29	104
35	Kurochkin P.A. (qwrqwr)	2	5	30	52
36	Strazov I.P. (Ivan Strazov)	2	5	30	28900
37	Evsa I.E. (Igor E)	2	5	30	30
38	Vukolov A. (al.vuk)	2	5	30	57
39	Zhdamorev (zda)	2	5	32	64
40	Petrov Y. (YuriPetrov)	2	5	33	34
41	Zakharov N.A. (Tchexp)	2	5	33	143
42	fioletovaya (fioletovaya2)	2	5	33	323
43	Frolov K.A. (Murderface_)	2	5	34	7311
44	Chuvstvin M. (chuvstvinmaxim)	2	5	34	171
45	Belskiy V. (Gambit87)	2	5	34	1406
46	Vasev A.V. (Vasev_Aleksey)	2	5	35	89
47	Varenikov D.M. (Dmitriy Varenikov)	2	5	36	96
48	Lyubomudrov R.G. (born2tilt)	2	5	37	38
49	Karasyova N.V. (vlksm)	2	5	38	162
50	Makarov I.A. (_Bkmz_)	2	5	38	42
51	Timofeeva E.V. (Umrikhina)	2	5	38	74
52	Polyakov V.M. (rock_4)	2	5	38	30307
53	Gapsatarov R.R. (gaspik336)	2	5	39	4849
54	Il'in A.N. (ani42)	2	5	41	82
55	Naumov A.D. (wad881988)	2	5	41	116
56	Rudikov E. (cubie)	2	5	41	46
57	Rudnev V.V. (pazartesi)	2	5	41	4189
58	Mordvintseva A.E. (ashigray)	2	5	43	871
59	Moskvin P. (Respect)	2	5	44	104
60	Fulman N.M. (Nir_)	2	5	44	612
61	Metalnikov (kirillmet)	2	5	44	146947
62	Latyntsev N.G. (aks_nsk)	2	5	45	949
63	Sajfullina E.F. (elena-fairy)	2	5	45	2944
64	Strel'chenko A.V. (saphirion)	2	5	45	277
65	Dudochkin A. (dandr)	2	5	46	62
66	Pupkin (Kikimora)	2	5	47	1188
67	Fedevych V.I. (labuch_fedev)	2	5	47	52
68	Box (Box)	2	5	48	143
69	Kulemzin N.E. (Bulochka_c_izumom)	2	5	49	352
70	Ikramov R. (ARNET)	2	5	49	97
71	Tkachenko D. (_GUERNIKA_)	2	5	49	2606
72	Levina A.V. (Anastasiya_mr)	2	5	50	59
73	Kislitsyn P. (kisslitsyn)	2	5	52	431
74	Golinskij M.O. (motcan2)	2	5	52	960
75	Safronov P.A. (Paulus73)	2	5	53	55
76	Vestnikov D.A. (letsstudybegin)	2	5	54	2892
77	Savin A.Yu. (mirovingin)	2	5	55	66
78	Kocherov E.S. (ssense)	2	5	56	198
79	Vinogradova S.M. (Tigra1)	2	5	57	74
80	Kadomtsev S.I. (z00mz00m1993)	2	5	58	329
81	Komarov A.N. (Shveda Saulya)	2	5	59	233
82	Rodionov S. (oldos)	2	5	59	75
83	Ryabov V.E. (vlal)	2	5	59	471
84	Maksimov I. (igor pupa)	2	5	60	4495
85	Nikitin A.A. (Quaero)	2	5	61	11440
86	Fomichev A.V. (Fomichev)	2	5	62	15913
87	Chebykin D. (GriGrim)	2	5	63	347
88	Voronkov O.A. (elafonisy)	2	5	64	113
89	Yakushev E.A. (Ejhi)	2	5	66	78
90	Abdulmanapov A. (Dvarik)	2	5	68	1409
91	Kostyushko Yu.V. (kostushko)	2	5	69	138
92	Kad V.Y. (s108)	2	5	71	336
93	Sazonov A. (an56111)	2	5	72	2761
94	Avdeenko I. (Igor_001)	2	5	72	141
95	Bulyakarov S. (Sa1avat)	2	5	73	1401
96	ASI (asi_sql)	2	5	73	872
97	Yakshin I.V. (ivan_y)	2	5	74	4247
98	Palasukhin D.S. (Nitrinos)	2	5	74	220
99	Blinov R.K. (Blini)	2	5	76	116
100	Kuritsyn V.N. (ValNick)	2	5	77	138

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 #5

Top 100 of the second stage at the
time of solving the exercise #5