SQL exercises

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

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