Rating of second-stage exercises (median) on SQL Exercises

July 31, 16:17 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

Rating of 2nd-stage exercises (median)

Rating of second-stage exercises (average)

No - exercise number; Bonus - level of difficulty;
Solved - number of visitors, who have solved this exercise;
Time(min) - the median time (calculated over all participants) that has been spent for solution in minutes;
noOK - number of visitors, who have not solved this exercise yet.
(Click on a cell to see list of these);
Length - wording length in symbols;
Rank - average score on a result of voting.

No	Bonus	Solved	Time(min)	noOK	Length	Author	Date	Rank
263	4	9	31871	5	549	pegoopik	2015-08-28	9.2 (5)
237	3	4	15761	1	1123	Baser	2022-05-13	9.7 (3)
147	4	29	14593	2	1213	$erges	2010-08-06	9.7 (20)
157	3	25	13065	3	960	anddros	2009-06-05	9.6 (16)
217	2	4	13034	0	272	pegoopik	2025-02-14	8.7 (3)
163	3	20	11408	0	1640	Ozzy	2010-01-08	9.7 (15)
143	5	48	11333	14	1159	inkerman	2007-10-07	8.8 (32)
214	4	11	10103	0	433	pegoopik	2015-05-30	10.0 (7)
155	3	29	10042	2	761	vlksm	2009-04-17	10.0 (20)
259	4	22	9370	2	276	anddros	2009-08-24	9.5 (13)
216	3	11	8681	1	279	pegoopik	2015-05-15	9.9 (8)
181	4	15	8489	1	1869	Ozzy	2011-10-08	9.7 (10)
194	4	15	7997	2	1461	pegoopik	2012-07-13	10.0 (11)
253	3	30	7278	8	1097	$erges	2008-05-17	8.9 (20)
161	3	23	6968	3	889	Ozzy	2009-11-06	9.3 (18)
257	4	17	6467	1	2758	pegoopik	2012-02-20	9.4 (13)
138	5	149	6385	35	949	Cyrilus	2005-12-09	9.2 (67)
224	3	11	6363	0	1979	selber	2017-04-14	9.5 (8)
206	4	14	6127	0	1484	Baser	2013-11-23	9.1 (12)
234	3	6	6045	1	1481	Kursist	2020-02-28	9.8 (4)
230	2	8	5920	1	728	pegoopik	2018-07-27	9.8 (5)
231	3	6	5903	0	787	mcrain	2018-08-24	10.0 (4)
211	2	14	5791	1	588	Baser	2014-06-30	9.8 (9)
255	4	14	5666	4	793	vlksm	2012-02-14	9.8 (9)
225	2	11	5571	0	737	pegoopik	2017-07-15	9.9 (7)
229	3	7	5468	1	1532	al29	2018-03-23	9.7 (6)
154	4	28	4892	3	848	anddros	2009-03-18	9.9 (19)
160	3	28	4731	0	961	Ozzy	2009-08-07	9.6 (18)
190	4	17	4683	1	717	vlksm	2012-03-17	8.9 (14)
159	3	18	4480	1	565	anddros	2012-07-22	8.2 (14)
220	3	7	4388	1	1175	pegoopik	2016-12-17	10.0 (4)
191	3	14	4212	0	948	qwrqwr	2012-06-08	9.5 (11)
252	2	35	3918	3	308	Ozzy	2009-06-14	8.4 (23)
149	3	36	3891	3	506	$erges	2008-09-08	9.3 (22)
172	3	23	3717	0	1719	Ozzy	2011-03-11	9.8 (16)
171	3	20	3682	1	1670	Ozzy	2010-12-05	9.3 (16)
116	5	257	3492	21	469	$erges	2008-12-13	9.4 (126)
218	4	13	3491	2	1500	al29	2016-04-04	9.6 (8)
189	4	15	3350	0	1563	Baser	2012-02-05	8.6 (12)
178	3	23	3302	1	1680	Baser	2011-08-13	9.1 (15)
151	3	37	3290	4	1096	anddros	2008-12-30	8.9 (21)
188	3	17	3191	1	733	qwrqwr	2012-02-04	9.8 (12)
167	3	26	3087	0	674	qwrqwr	2011-01-18	9.7 (16)
208	3	14	3063	0	821	pegoopik	2013-12-20	8.8 (12)
153	3	39	3047	4	1539	Ozzy	2009-02-14	9.3 (21)
156	2	53	3030	3	391	anddros	2009-04-17	9.1 (30)
144	4	47	2996	4	950	pvv	2008-01-01	7.4 (30)
187	3	26	2965	0	978	=Maxim=	2011-12-31	8.8 (21)
119	5	120	2943	4	703	Velmont	2014-03-07	9.6 (64)
232	3	6	2940	0	513	al29	2018-08-20	10.0 (5)
100	4	267	2919	9	650	qwrqwr	2010-04-27	9.4 (135)
102	4	195	2588	8	933	GriGrim	2011-07-16	9.5 (93)
221	2	17	2539	1	1023	Baser	2016-11-05	8.9 (10)
223	2	13	2357	0	641	Baser	2016-11-12	9.9 (8)
141	4	81	2335	12	977	vlksm	2006-10-29	9.0 (36)
179	3	17	2329	0	844	pegoopik	2011-09-17	9.2 (12)
210	2	15	2132	1	483	_dimon_	2014-02-07	10.0 (11)
101	4	230	2125	20	1096	pegoopik	2010-11-20	9.3 (123)
120	4	117	2008	2	239	pegoopik	2014-02-14	9.1 (58)
145	3	72	2007	1	859	pvv	2008-01-07	8.7 (34)
184	2	26	1953	1	432	Baser	2011-11-26	8.9 (20)
227	3	10	1948	1	2142	mcrain	2017-12-08	7.3 (6)
164	2	38	1943	2	1622	anddros	2010-04-26	9.7 (22)
98	4	600	1912	44	538	ZrenBy	2003-09-01	8.2 (139)
148	2	68	1910	7	894	vlksm	2008-09-06	9.3 (36)
72	4	1045	1882	149	632	paparome	2005-12-03	9.2 (286)
205	2	16	1877	0	529	qwrqwr	2013-11-22	8.9 (10)
193	2	22	1798	0	522	Baser	2012-07-06	8.3 (15)
150	4	38	1780	6	909	@Nikotin	2008-11-09	8.6 (22)
182	3	23	1717	0	1377	Baser	2011-10-29	8.1 (17)
222	2	15	1664	0	1475	pegoopik	2016-12-23	9.8 (9)
175	3	31	1654	1	2151	pegoopik	2011-04-28	8.5 (22)
89	3	431	1654	32	870	_Bkmz_	2008-06-21	7.9 (165)
137	4	198	1618	25	616	Cyrilus	2005-03-06	9.2 (70)
183	2	30	1611	2	518	GriGrim	2011-11-12	9.1 (15)
146	3	63	1606	3	949	paparome	2008-01-22	9.7 (34)
87	4	655	1604	89	459	Roman Golubin	2006-07-14	9.3 (184)
200	3	19	1586	0	1129	qwrqwr	2013-10-05	9.3 (13)
165	2	32	1544	3	1600	vlksm	2010-03-18	9.8 (19)
228	1	19	1540	1	1419	qwrqwr	2018-01-12	10.0 (11)
169	3	33	1534	0	1559	Valdaj	2010-09-02	8.5 (22)
121	3	418	1529	4	804	ZrenBy	2004-02-26	7.6 (103)
176	3	33	1519	0	385	qwrqwr	2011-05-20	9.5 (22)
136	3	122	1511	5	618	Ozzy	2011-05-12	7.5 (53)
196	3	25	1494	0	661	qwrqwr	2013-05-17	9.4 (15)
135	3	73	1483	2	854	qwrqwr	2013-04-19	9.1 (39)
219	2	17	1482	0	486	pegoopik	2016-04-08	9.9 (9)
132	3	119	1472	4	2500	risp	2010-01-25	7.5 (59)
158	3	39	1452	0	1174	Ozzy	2010-04-09	8.9 (23)
198	2	23	1444	1	332	Angellore	2013-09-13	9.4 (16)
152	3	49	1420	4	1301	vlksm	2009-01-05	9.6 (28)
233	1	17	1394	0	2321	pegoopik	2019-03-08	10.0 (9)
180	3	32	1375	0	274	qwrqwr	2011-09-16	9.6 (24)
68	3	327	1372	28	594	pegoopik	2014-08-01	8.1 (123)
85	3	388	1368	19	1397	Ozzy	2009-10-10	8.5 (153)
199	3	20	1350	0	1448	Baser	2013-08-17	8.4 (14)
213	2	26	1346	0	369	qwrqwr	2014-10-17	9.6 (15)
76	3	481	1344	16	915	silver	2010-01-23	8.8 (191)
215	2	23	1326	0	331	pegoopik	2015-03-06	9.3 (13)
212	3	16	1319	0	585	Baser	2014-10-14	8.9 (10)
168	2	44	1310	2	455	qwrqwr	2010-08-27	9.5 (25)
123	3	257	1310	38	1254	Ozzy	2009-08-22	9.0 (120)
82	3	411	1289	12	1780	_Virt_	2010-04-27	8.2 (154)
207	3	17	1255	0	486	pegoopik	2016-01-15	10.0 (9)
226	3	11	1235	1	2054	pegoopik	2017-10-14	9.3 (6)
69	2	204	1223	9	210	Gosha	2017-12-15	9.1 (69)
186	1	37	1215	0	1447	Ozzy	2011-12-30	9.2 (24)
173	1	53	1209	3	945	Ozzy	2011-01-13	9.3 (29)
106	3	295	1206	5	647	vlksm	2008-11-27	8.8 (129)
77	2	335	1194	31	1053	selber	2015-07-10	8.7 (138)
65	3	755	1155	51	599	Ozzy	2010-01-29	7.7 (263)
84	3	438	1154	17	815	Ozzy	2009-12-26	8.3 (162)
96	3	431	1139	81	572	anddros	2008-11-22	8.8 (171)
32	3	110	1092	16	476	blr_Oliver	2023-07-08	9.1 (36)
93	3	186	1086	5	492	qwrqwr	2014-03-14	9.3 (78)
57	2	224	1061	16	537	Kursist	2020-10-10	8.4 (66)
134	3	182	1041	4	821	pvv	2008-01-22	8.6 (73)
140	2	84	925	2	578	_Bkmz_	2010-01-30	8.9 (42)
37	3	837	866	25	576	qwrqwr	2013-02-22	8.0 (278)
71	3	568	805	25	909	anddros	2009-12-26	8.4 (198)
125	3	382	704	3	526	dimzv	2004-02-29	8.7 (95)
185	1	44	688	3	782	=Maxim=	2011-11-25	7.9 (26)
195	3	27	658	0	722	Dmitrij Grinkevich	2013-04-20	9.1 (16)
110	3	445	646	11	942	Snowbear	2006-03-14	8.9 (123)
126	2	194	633	11	944	$erges	2008-09-07	8.6 (95)
251	4	68	594	3	850	paparome	2006-10-01	8.0 (29)
162	2	61	592	1	1067	Ozzy	2009-12-26	9.3 (34)
307	2	19	553	0	1095	Baser	2017-06-29	8.5 (11)
174	1	58	535	0	1084	qwrqwr	2011-02-25	9.3 (34)
130	2	128	534	1	700	anddros	2010-05-22	8.9 (63)
58	3	685	532	14	397	qwrqwr	2013-03-01	8.1 (234)
99	3	213	471	8	956	Dmitrij Grinkevich	2012-05-05	8.2 (88)
107	2	418	467	9	688	Fiolent	2004-02-26	8.0 (108)
66	3	706	449	56	423	anddros	2009-12-26	8.5 (260)
254	1	45	420	1	1383	Baser	2011-09-02	8.8 (27)
127	2	70	406	2	985	GriGrim	2014-12-21	8.2 (32)
177	1	55	390	0	935	pegoopik	2011-07-17	8.5 (27)
202	2	30	390	1	557	qwrqwr	2013-11-01	9.1 (16)
64	3	652	380	51	506	qwrqwr	2010-05-13	8.1 (202)
142	2	118	379	1	944	paparome	2007-03-24	9.0 (49)
108	3	293	370	5	521	crescent	2011-03-23	8.9 (119)
5	1	215	365	173	224	Serge I	2023-06-18	8.4 (65)
166	1	64	358	1	449	anddros	2010-07-26	9.6 (32)
23	3	1638	356	126	307	Palkin	2007-03-29	8.4 (394)
115	2	94	348	1	736	selber	2016-05-28	9.0 (42)
170	2	59	347	1	320	qwrqwr	2010-10-24	9.1 (31)
80	2	366	345	11	448	qwrqwr	2011-10-21	9.0 (145)
92	2	575	310	9	405	paparome	2006-07-26	8.5 (129)
139	2	129	295	2	907	Snowbear	2006-09-09	8.3 (46)
209	1	34	280	1	735	Baser	2013-12-30	8.0 (15)
12	1	537	278	48	348	Serge I	2019-04-12	7.0 (123)
111	2	467	272	3	545	Fiolent	2005-01-19	8.3 (106)
36	3	1105	269	23	786	risp	2011-05-06	8.0 (332)
29	2	1159	254	40	799	GiBis	2011-09-17	7.5 (354)
47	3	1022	253	14	554	qwrqwr	2010-11-20	8.1 (311)
45	2	521	250	14	473	dumkan	2016-04-03	8.0 (141)
54	2	1409	250	45	796	Ozzy	2008-09-06	8.2 (483)
41	3	1190	250	18	253	qwrqwr	2010-04-26	8.1 (376)
262	2	14	243	2	740	selber	2019-06-21	8.3 (7)
204	1	37	241	1	366	anddros	2013-11-19	8.5 (19)
67	2	619	238	17	617	Ozzy	2010-04-27	8.3 (216)
60	3	2128	232	119	313	Serge I	2005-03-05	7.9 (351)
118	2	439	228	1	206	Fiolent	2004-01-05	8.1 (95)
133	2	100	224	0	1614	pickman	2011-07-01	8.3 (51)
91	2	243	222	1	642	smog	2012-05-26	9.1 (98)
105	2	153	211	0	610	Baser	2013-09-20	8.6 (60)
122	1	147	207	2	725	Dmitrij Grinkevich	2012-09-14	5.9 (60)
34	2	1253	207	28	765	qwrqwr	2010-09-24	7.9 (374)
129	2	283	206	7	658	DimaN	2004-03-01	7.5 (64)
43	2	598	198	3	597	qwrqwr	2015-04-24	8.4 (186)
95	1	115	195	2	350	qwrqwr	2017-12-01	9.4 (46)
75	2	427	186	4	587	qwrqwr	2011-07-22	7.5 (154)
260	2	53	183	0	999	qwrqwr	2012-02-03	7.7 (37)
40	1	381	180	10	398	Serge I	2018-09-07	7.0 (98)
20	2	1584	179	34	327	VIG	2003-09-01	8.0 (356)
62	2	777	178	11	576	Dmitrij Grinkevich	2012-02-11	8.1 (240)
86	2	369	177	0	433	Ozzy	2010-03-05	8.6 (124)
261	1	35	169	1	1495	Fomichev	2013-12-07	7.0 (19)
59	2	981	168	6	203	VIG	2003-12-22	8.3 (218)
38	2	1103	168	27	302	ZrenBy	2003-09-01	7.6 (223)
49	2	1251	165	22	891	anddros	2009-06-05	7.9 (389)
61	2	1031	161	5	772	risp	2009-12-26	8.5 (334)
124	2	388	160	3	455	DimaN	2004-02-26	8.2 (91)
304	2	25	151	0	1132	aks_nsk	2016-02-05	9.4 (16)
74	2	696	143	8	794	vlksm	2008-06-21	8.4 (214)
7	1	374	142	111	513	Baser	2021-02-27	8.0 (82)
131	2	101	142	1	498	GriGrim	2012-05-25	8.7 (47)
203	1	43	139	1	932	=Maxim=	2013-10-05	9.4 (26)
109	2	507	132	1	671	VIG	2003-12-23	8.0 (102)
16	2	1009	127	60	336	qwrqwr	2014-07-18	7.5 (268)
201	2	40	127	0	749	Baser	2013-09-21	8.8 (25)
303	2	12	127	0	687	selber	2023-12-27	9.3 (7)
39	2	1447	126	23	256	Serge I	2003-08-28	7.5 (295)
78	2	443	124	5	404	_ORA_	2010-04-27	7.5 (135)
83	2	559	120	5	798	lepton	2006-09-29	8.6 (157)
81	2	620	118	12	707	$erges	2008-05-10	8.3 (175)
51	1	630	118	15	416	Fiolent	2004-06-23	8.3 (167)
55	2	635	116	6	339	VIG	2005-06-26	7.8 (128)
35	3	657	110	12	695	Baser	2015-09-18	8.7 (193)
94	2	274	110	0	773	pickman	2011-04-27	8.3 (98)
33	2	1337	107	26	364	DimaN	2004-03-01	7.7 (362)
236	1	13	106	0	467	Baser	2021-07-24	9.7 (9)
104	1	154	104	0	571	pegoopik	2013-07-19	8.4 (66)
128	1	238	104	4	829	inkerman	2007-09-14	8.4 (77)
79	1	992	102	14	333	Serge I	2003-06-05	7.8 (162)
197	1	46	102	0	518	pegoopik	2013-06-10	8.9 (21)
44	2	809	99	8	273	Serge I	2011-11-25	7.9 (250)
90	1	255	99	1	499	Dmitrij Grinkevich	2012-03-03	8.0 (90)
17	2	1744	98	27	122	VIG	2003-04-29	8.2 (340)
52	1	570	97	3	268	Serge I	2015-01-10	8.6 (163)
73	1	487	97	3	306	Ruslan1707	2010-11-02	7.5 (159)
70	1	703	94	3	303	Serge I	2009-04-17	7.9 (228)
46	2	1266	94	127	340	Serge I	2009-08-12	6.9 (336)
6	2	2238	93	126	281	Serge I	2005-05-07	8.0 (398)
113	1	150	92	0	497	smog	2013-03-29	8.7 (62)
305	1	26	91	1	160	Baser	2017-01-06	9.1 (15)
103	1	154	87	1	850	Baser	2013-10-05	7.6 (63)
114	1	465	83	4	298	Serge I	2003-12-24	8.5 (101)
256	1	41	82	1	436	anddros	2013-11-08	9.0 (21)
238	2	7	81	0	1143	Baser	2022-05-13	8.6 (5)
24	2	1707	79	6	685	Aaz	2004-02-26	7.0 (472)
26	1	1563	79	28	289	VIG	2003-12-22	7.7 (370)
235	2	10	78	0	665	Kursist	2021-07-10	9.6 (7)
25	2	1316	75	30	232	DimaN	2004-06-22	7.2 (339)
50	1	616	74	16	421	mslava	2003-12-23	7.1 (124)
9	2	1532	72	32	498	vasia armor	2010-05-21	8.0 (438)
10	1	866	71	48	179	Serge I	2017-01-20	8.1 (236)
28	1	1293	70	11	283	ZrenBy	2003-09-01	7.6 (245)
112	1	59	69	2	393	Gosha	2020-06-03	8.7 (26)
8	2	1630	66	95	600	Serge I	2008-06-21	7.7 (399)
97	1	386	63	4	231	dimzv	2004-03-01	7.6 (87)
21	1	1295	62	10	709	paparome	2006-03-14	8.1 (290)
18	1	1724	56	12	157	ZrenBy	2003-09-01	7.7 (373)
42	1	1685	55	15	249	Serge I	2003-06-05	7.7 (335)
239	2	4	54	0	426	pegoopik	2025-02-21	9.3 (3)
192	2	51	52	0	709	Baser	2012-03-03	9.2 (26)
27	1	1359	52	8	376	Fiolent	2004-02-26	7.4 (311)
117	1	442	52	0	193	Fiolent	2003-12-26	7.7 (91)
30	1	1833	50	3	205	Serge I	2003-08-28	7.9 (405)
48	1	1227	50	6	252	Serge I	2009-06-22	7.4 (323)
63	1	1399	48	5	190	VIG	2003-06-05	7.6 (253)
22	1	1707	48	13	270	ZrenBy	2003-09-01	7.4 (392)
14	1	2551	47	39	116	Serge I	2003-04-08	7.6 (450)
19	1	2087	47	23	269	Serge I	2004-06-23	7.5 (425)
56	1	1120	46	3	565	Fiolent	2004-06-22	8.0 (290)
88	2	59	45	1	293	Serge I	2021-10-15	9.3 (20)
302	0	38	45	0	510	pegoopik	2012-07-27	7.8 (12)
31	1	1126	43	6	349	Fiolent	2004-06-22	7.9 (274)
13	1	1839	40	22	194	ZrenBy	2003-09-01	7.6 (423)
53	1	1533	37	25	234	DimaN	2004-03-01	7.7 (394)
15	1	1316	36	7	287	Dmitrij Grinkevich	2012-04-21	7.7 (340)
11	1	2029	35	16	130	ZrenBy	2003-09-01	7.6 (451)
306	1	15	30	1	363	Baser	2022-04-29	8.3 (8)
258	3	25	13	1	1070	Baser	2014-09-19	7.6 (10)
301	0	45	8	0	55	pegoopik	2012-03-23	8.7 (22)
240	3	1		1	1200	pegoopik	2025-07-25

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References