SQL exercises

October 24, 09:45 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
  • Visual simulation (painting)
  • Exercises voting

Forums

  • Learning stage
  • Rating stages
  • Favorites
  • Search
  • Blogs

Certification

  • Certified professionals
  • Statistics
  • Statistics over regions (map)
  • Confirm certificate

HELP

Query optimization

For employers

Support SQL-EX.RU

"Liberal" rating

Exercise solution time exceeding 6 hours is replaced by 6 hours.
Only 2nd and 3rd stage exercises are considered in solution time (Days_2).
Scores - sum of points on 2nd & 3rd stage exercises and DML exercises solved.

Involved in rating: 12706
Involved in second stage rating: 3367

No	Person	Number of Sel_ex	Last_Sel	Number of DML_ex	Scores	Days	Days_2	LastSolved	LastVisit
1	Chernov D.V. (Kursist)	247	307	43	644	1501	46.780	10 Oct 2020	24 Oct 2020
2	Kreslavskij O.M. (Arcan)	245	307	43	639	5002	36.863	10 Oct 2020	20 Oct 2020
3	Krasovskij E.A. (pegoopik)	243	307	42	636	3459	21.241	09 Dec 2019	21 Sep 2020
4	Doschenko V.N. (mcrain)	239	307	43	623	3199	47.262	24 Jun 2020	07 Oct 2020
5	Boiko D. (Angellore)	237	307	40	618	4307	41.176	23 May 2019	21 Sep 2020
6	Kostomarov A.V. (al29)	238	307	38	618	3034	44.609	10 Aug 2020	22 Oct 2020
7	Dubinskij A.V. (_velial)	234	307	43	615	4473	33.366	27 Aug 2020	11 Oct 2020
8	Karasyova N.V. (vlksm)	235	307	42	612	5103	37.310	25 Apr 2020	17 Oct 2020
9	Bezhaev A.Yu. (Baser)	234	307	34	603	2924	31.821	04 May 2018	01 Aug 2020
10	Kurochkin P.A. (qwrqwr)	231	307	40	595	3888	32.091	03 Jul 2020	20 Oct 2020
11	Filippkin D.V. (_dimon_)	225	307	43	593	4549	28.635	08 Jun 2020	02 Jul 2020
12	Movlyanov A.P. (Oct)	217	305	29	552	1307	32.248	23 Jan 2017	27 Aug 2018
13	Vyazovetskov A.S. (alex_v)	216	301	23	529	4368	32.536	17 May 2018	11 Mar 2020
14	Sal'nikov S.A. ($erges)	200	302	25	513	2533	14.362	02 Feb 2015	01 Oct 2020
15	Kukushkin S.A. (smog)	197	305	29	488	2379	30.082	03 Oct 2017	04 Jun 2020
16	Varenikov D.M. (Dmitriy Varenikov)	196	307	43	483	5408	37.146	08 Aug 2020	22 Aug 2020
17	Timofeeva E.V. (Umrikhina)	182	304	41	462	4234	16.441	27 Nov 2019	30 Dec 2019
18	Koptel'tsev V. (selber)	179	307	43	459	2982	30.484	13 Oct 2020	23 Oct 2020
19	Aliev R. (y4nzi)	184	307	33	452	249	21.698	25 Jan 2018	24 Mar 2019
20	Pusev D.V. (Pusev_Denis)	176	254	40	439	979	25.643	14 Jul 2020	18 Jul 2020
21	Sigankov V.I. (vasilyvanc)	176	307	43	439	2516	26.791	11 Oct 2020	21 Oct 2020
22	Grinkevich D.L. (Dmitrij Grinkevich)	179	302	27	433	2060	24.028	31 May 2017	24 Aug 2020
23	Yatsuk A.A. (Faust_zp)	166	301	24	431	1985	18.959	12 Jul 2012	15 Feb 2019
24	Zajtsev V.S. (Sleeping)	184	307	27	426	3617	21.616	17 Apr 2018	04 Mar 2019
25	Williams B. (BW)	175	307	41	425	4029	37.238	20 Feb 2020	14 Oct 2020
26	Chebykin D.N. (GriGrim)	175	307	34	424	4959	26.456	29 Dec 2019	12 Feb 2020
27	Fedevych V.I. (labuch_fedev)	173	305	40	423	2272	23.889	20 Apr 2020	20 Apr 2020
28	Shkarednyj I.N. (Gosha)	169	305	43	422	5295	31.062	16 Jul 2020	23 Oct 2020
29	Petrov Y. (YuriPetrov)	172	305	40	419	3063	21.260	04 Jul 2019	15 Sep 2019
30	Fokin A. (Vizitor )	159	302	41	417	2905	12.069	17 Aug 2019	06 Sep 2019
31	Drozdkov A.N. (anddros)	166	302	24	411	2246	10.050	21 Jul 2014	05 Jun 2020
32	Latyntsev N.G. (aks_nsk)	162	307	40	405	2701	16.999	21 May 2019	24 Oct 2020
33	Shaymardanov M.M. (xLiSPirit)	159	301	34	399	2794	19.652	18 May 2018	20 Dec 2018
34	Kuznetsov V.S. (herrRo)	152	260	23	390	1171	19.255	08 Feb 2012	18 Jun 2013
35	Pyatiletov A. (MontaG)	155	302	39	379	2482	22.410	30 Jun 2019	30 Jun 2019
36	Pavlov A.V. (Anton)	153	261	40	378	5051	22.541	11 Jun 2019	18 Aug 2019
37	F (uff)	155	305	31	375	1539	27.936	22 Jan 2018	20 Aug 2018
38	Titovskij P.S. (kli3ma)	147	260	28	369	1906	14.296	15 Jun 2016	15 Jun 2016
39	Tarasov D.B. (Gavrila)	144	301	23	365	2432	20.069	23 Apr 2012	08 Jan 2018
40	Milenkov (wqer)	135	148	43	362	1525	19.037	12 Jul 2020	30 Sep 2020
41	Shindin A.V. (AlShin)	140	259	23	360	3622	20.324	18 Sep 2018	06 Oct 2018
42	Agapov V. (KERBEROS)	141	302	24	358	2414	15.988	02 Apr 2013	24 Sep 2016
43	Utyonkov M.N. (=Maxim=)	151	302	24	356	4541	14.813	08 Oct 2018	11 Dec 2018
44	Vakhrameev A. (WY)	146	302	25	355	1446	14.882	18 Jan 2015	28 Jun 2020
45	Grishunin M.F. (MikhailFG)	136	301	38	355	776	22.949	25 Jan 2019	18 Dec 2019
46	Halushka B. (halushka)	147	302	20	351	285	16.352	19 Oct 2015	22 Jan 2016
47	Samarin A. (not.yet.sql.master)	130	137	42	349	262	5.106	09 May 2020	14 Aug 2020
48	Familiya (WereWolf777)	130	170	38	343	3576	14.255	07 Jan 2019	07 Jan 2019
49	Orlov M.V. (Eagleoff)	132	259	23	342	1299	18.368	07 Nov 2011	05 Dec 2019
50	Suprun D. (TimonSP)	131	143	29	341	3033	8.081	09 Jan 2017	26 Feb 2019
51	Komarov A.N. (Shveda Saulya)	128	134	43	341	293	15.019	08 Aug 2020	19 Oct 2020
52	Proskurin Yu.N. (Xonner)	138	301	29	340	2647	15.823	23 Jun 2018	11 Jul 2020
53	Ilyasov V. (VadimI)	134	260	29	339	1109	11.201	13 Mar 2017	03 Apr 2017
54	Zotov P.G. (Ozzy)	130	259	23	338	1391	18.782	31 Dec 2011	18 Aug 2016
55	Frolov (dr.shtopor)	130	148	28	334	865	22.019	05 Apr 2016	31 Dec 2019
56	Kalinin K.A. (kalinin_k)	135	301	23	333	399	11.758	30 Jun 2012	19 Nov 2014
57	Maslyaev V.S. (Velmont)	136	302	27	332	2261	12.559	02 Feb 2018	02 Jul 2019
58	Sivoglazov M.A. (Gaizenberg)	139	301	24	332	842	16.579	10 Nov 2015	10 Aug 2020
59	Demin D. (demind74)	125	133	40	328	301	9.179	01 Jul 2019	20 Aug 2019
60	Skorohod I. (Dracul4ik)	130	254	25	326	2300	23.574	12 Sep 2017	10 Sep 2019
61	Ivanova O.A. (_Olga24)	125	138	29	324	803	14.463	14 Aug 2016	14 Aug 2016
62	Vasilevskaya E.A. (kattiks)	123	130	41	324	907	21.882	30 Aug 2019	20 Jul 2020
63	Dvoryaninov V. (Valdaj)	133	301	23	323	1291	18.065	28 Dec 2012	28 Apr 2020
64	Azbel' E.G. (enull)	127	143	25	323	3441	21.391	21 Feb 2018	05 May 2020
65	Menshov S. (SergM)	129	260	26	321	3733	13.499	02 Jun 2017	18 Oct 2020
66	X D. (railgun3r)	128	302	24	320	1378	22.571	16 Aug 2014	03 Nov 2015
67	Martynyuk (Wiedzmen)	133	251	23	319	2190	15.068	10 Mar 2015	08 Feb 2016
68	Kolesnikov (hard)	124	133	34	318	1583	19.568	24 Nov 2018	02 Oct 2020
69	Buldenkov D.A. (eXeQuThor)	118	125	41	315	4456	11.791	28 Oct 2019	02 Dec 2019
70	Dmitriev A. (Havr)	118	125	41	315	334	12.748	30 Jul 2019	12 Sep 2019
71	Yakovlev M.V. (MikhailYakovlev535)	116	303	43	315	1842	13.890	08 Jul 2020	23 Oct 2020
72	Khromulyak O.M. (ChOleg)	125	254	25	314	2075	27.954	25 Jul 2015	30 Aug 2018
73	Zhulanov S.G. (borey.mdb)	118	125	40	313	798	14.395	20 Jul 2019	29 Jul 2019
74	Derzhal'tsev V.A. (MadVet)	121	259	22	313	2083	17.722	29 Dec 2010	14 Oct 2015
75	Zin4uk V. (Zin4uk Vadim)	125	260	24	313	1342	20.676	24 Jun 2014	02 Sep 2014
76	Panfilov A. (alexey.p4nfilov)	117	125	40	312	147	11.627	06 Jun 2019	21 Aug 2019
77	Osin V. (anyman1979)	116	125	40	311	800	6.045	03 Nov 2019	03 Nov 2019
78	Kirdan (shipwright)	117	126	38	311	1955	18.899	05 Dec 2018	05 Dec 2018
79	Kabanets E.G. (azkaban)	127	302	25	309	2234	15.212	30 Dec 2015	31 Dec 2015
80	Aronov O. (aronov.oleg)	122	136	34	307	3038	16.380	19 Dec 2019	06 Jul 2020
81	Vorob'ev E.V. (Johnnymnemonic)	126	137	25	307	3500	20.876	09 Jun 2017	24 Aug 2020
82	Vysotskij M.N. (IvanMan)	122	136	26	305	1376	15.958	12 Jan 2016	12 Jan 2016
83	Vojtov A. (Lesha.V)	116	125	35	304	708	15.072	25 Jul 2018	06 Nov 2019
84	Vas'kov E.V. (Johan)	123	260	24	302	2585	14.178	16 Aug 2013	11 Jun 2020
85	Zvon (pavel1211)	116	125	34	302	1754	15.754	06 Jul 2018	04 Nov 2019
86	Kozlov V. (SN 209)	116	125	34	302	3300	19.336	26 May 2018	03 Jun 2020
87	Kozlova M.S. (Margarita_K)	116	126	33	301	310	16.809	11 Jan 2018	05 Sep 2019
88	Shuravin E.P. (dumkan)	118	131	28	299	186	14.506	13 Apr 2016	21 Oct 2019
89	Ermolov N. (SQL_DBA)	119	133	27	299	1093	18.268	05 Jul 2016	25 Jul 2020
90	Grecha (grecha)	125	256	24	298	170	8.307	26 Feb 2014	11 Mar 2016
91	Grishin (alvigr)	124	302	24	298	1096	13.787	10 Dec 2014	19 Jan 2015
92	Katyukova I.A. (IrinkaR)	119	260	26	297	3374	10.752	15 Nov 2016	14 May 2020
93	Ovsyankin V.S. (Kazaam)	120	129	27	295	4016	10.727	23 Aug 2020	23 Aug 2020
94	Polyakov S.G. (Ivanoff Alex)	118	142	24	292	1703	20.168	29 Nov 2013	07 Aug 2020
95	Egorov Yu.A. (Yury Egorov)	123	260	23	288	1773	11.766	16 Apr 2016	16 Apr 2016
96	Rakhmatullin R. (Ranil)	117	125	27	287	2579	20.169	24 Jun 2020	25 Jun 2020
97	Agirre Kordova A.K. (Cordova)	116	125	26	286	267	9.939	04 Sep 2018	04 Aug 2020
98	Korol'kov A.A. (Brat Esteban)	116	125	26	285	3852	18.779	18 Sep 2018	13 Jul 2020
99	LisperWhisper (LisperWhisper)	115	133	24	282	2455	10.177	16 Apr 2019	16 Dec 2019
100	Tarshin S.N. (tsn)	116	122	26	277	3261	11.349	30 Jul 2020	16 Aug 2020

Home
Week news