SQL exercises

December 15, 21:51 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 #6

No	Person	SolvedEx	LastEx	Minutes	Bad time
1	gls (gls52)	2	6	1	70
2	Belskiy V. (Gambit87)	2	6	1	1406
3	Vol'khin S.A. (Sergei Volkhin)	2	6	1	406
4	Stich L.S. (Stitch05)	2	6	1	42
5	Govorov E. (erxaan)	2	6	1	8
6	Ivanov P.I. (sqlSolver123)	2	6	2	246
7	Rodionov S. (oldos)	2	6	3	59
8	Ryabov V.E. (vlal)	2	6	4	471
9	Novikov S.V. (@Ser589QA)	2	6	4	13
10	Voronkov O.A. (elafonisy)	2	6	5	113
11	Karpov I. (Dompaff)	2	6	5	73
12	Safonov A.A. (alexanderfm3)	2	6	6	4301
13	Komarov A.N. (Shveda Saulya)	2	6	7	59
14	Il'in A.N. (ani42)	2	6	7	82
15	Nn J. (DAKUCAPORYK)	2	6	7	112
16	Brushtejn E.V. (Kate_Bru)	2	6	8	93
17	Khokhlov A.N. (Khokhlov A.N.)	2	6	9	61
18	Sharova I.S. (LittleSnail)	2	6	9	35
19	Kostyushko Yu.V. (kostushko)	2	6	10	138
20	Sazonov A. (an56111)	2	6	10	2761
21	Nesov (STH80)	2	6	10	1514
22	Mordvintseva A.E. (ashigray)	2	6	10	871
23	Krasnov A.A. (Nutr1k)	2	6	10	12
24	Moskvin P. (Respect)	2	6	11	104
25	Dudochkin A. (dandr)	2	6	11	62
26	Ivanova S. (moonfish)	2	6	11	670
27	Yartsev Yu. (Yury66)	2	6	11	1454
28	Ikramov R. (ARNET)	2	6	11	49
29	Protasov D.E. (preblud)	2	6	12	123
30	Gavrilov (dzhoncheg)	2	6	14	751
31	Firstova A.O. (FAO)	2	6	14	4212
32	Kulemzin N.E. (Bulochka_c_izumom)	2	6	14	352
33	Lyubomudrov R.G. (born2tilt)	2	6	14	37
34	Murtazaliev M.G. (Magmur)	2	6	14	4948
35	Koptel'tsev V. (selber)	2	6	15	25
36	Ivanov P.S. (Phoenix_Cyrill)	2	6	15	212
37	Lisenenkova (Lisenenkova_E)	2	6	15	1384
38	Stepanova (Lectrasim)	2	6	15	41
39	Boyarskij V.A. (ChronoMorzh)	2	6	16	29
40	Vestnikov D.A. (letsstudybegin)	2	6	17	54
41	Marchenkov (Decoe)	2	6	17	7335
42	Gorodenko V.N. (gregory_aldente)	2	6	17	134036
43	Yakshin I.V. (ivan_y)	2	6	17	4247
44	Vukolov A. (al.vuk)	2	6	17	30
45	Zolotyh (Guy)	2	6	18	38
46	Krasovskij E.A. (pegoopik)	2	6	18	38
47	Garaev (ElfG)	2	6	18	219
48	Verendeev I.M. (ilyaverenSQL)	2	6	20	187
49	Markov A. (Sasha Markov)	2	6	21	823
50	fioletovaya (fioletovaya2)	2	6	21	323
51	Strel'chenko A.V. (saphirion)	2	6	21	277
52	Kreslavskij O.M. (Arcan)	2	6	22	214
53	Kharin E.A. (ekhavlad)	2	6	22	329
54	Kuritsyn V.N. (ValNick)	2	6	22	138
55	P I.*. (IrinaPetr)	2	6	22	2498
56	Mikhajlov A.S. (RainBowAM)	2	6	23	112
57	Nikitin A.A. (Quaero)	2	6	23	11440
58	Timofeeva E.V. (Umrikhina)	2	6	24	38
59	Rudikov E. (cubie)	2	6	24	46
60	Mityurin V. (mitvol)	2	6	25	1476
61	Filippkin D.V. (_dimon_)	2	6	26	38
62	Makarov I.A. (_Bkmz_)	2	6	26	42
63	Tarshin S.N. (tsn)	2	6	26	92
64	Strel'bitskij A. (Artem74)	2	6	26	1523
65	Zhitchenko A.I. (ArrenHawk)	2	6	26	34
66	Abdulmanapov A. (Dvarik)	2	6	26	1409
67	Iudin (xoreaxebx)	2	6	26	209
68	Sajfullina E.F. (elena-fairy)	2	6	26	2944
69	M (trewqQt)	2	6	26	1637
70	Stepochkin (AlexStepochkin)	2	6	26	272
71	Dorodnykh N.A. (nata_doro)	2	6	26	104
72	Evsa I.E. (Igor E)	2	6	26	30
73	Williams B. (BW)	2	6	27	34330
74	Bezhaev A.Yu. (Baser)	2	6	27	70
75	Risunova K. (agen4ik)	2	6	27	36
76	Lyaschenko S.N. (pimen78)	2	6	28	982
77	Chesnokov S.A. (SergeiCh90)	2	6	28	64
78	Avdeenko I. (Igor_001)	2	6	29	72
79	Lyaskovskij V.L. (blr_Oliver)	2	6	29	33
80	Kurochkin P.A. (qwrqwr)	2	6	30	79
81	Suprun D. (TimonSP)	2	6	31	56
82	Petrov Y. (YuriPetrov)	2	6	31	33
83	Strazov I.P. (Ivan Strazov)	2	6	31	28900
84	Khugaev (Robert_01)	2	6	31	3961
85	Savin A.Yu. (mirovingin)	2	6	32	66
86	Kinder M.M. (Kind)	2	6	33	100
87	Matvienko S.A. (Sergej Matvienko)	2	6	33	291
88	Sarkis'yan G. (gennadi_s)	2	6	33	83
89	Dubinskij A.V. (_velial)	2	6	34	53
90	Vinogradova S.M. (Tigra1)	2	6	34	74
91	Frolov K.A. (Murderface_)	2	6	34	593
92	Kocherov E.S. (ssense)	2	6	34	198
93	Blinov R.K. (Blini)	2	6	35	116
94	Nesutulov K.S. (Htomsik)	2	6	35	2647
95	Varenikov D.M. (Dmitriy Varenikov)	2	6	36	113
96	Tits S.I. (crafty_figure)	2	6	37	118
97	Karasyova N.V. (vlksm)	2	6	38	71
98	Sergeeva O.B. (Valkiri9)	2	6	39	49197
99	Gubarev (SqlLearner230)	2	6	39	56
100	Pak A. (alexey321)	2	6	39	56

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

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