SQL exercises

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

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