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

June 25, 11:37 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 (SELECT)
  • Exercises voting (DML)

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

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
217	4	9	31871	4	549	pegoopik	2015-08-28	9.2 (5)
147	4	27	14593	2	1213	$erges	2010-08-06	9.7 (19)
157	3	24	12925	2	960	anddros	2009-06-05	9.6 (15)
163	3	19	11408	0	1640	Ozzy	2010-01-08	9.6 (14)
143	5	46	11333	14	946	inkerman	2007-10-07	8.8 (30)
214	4	11	10103	0	433	pegoopik	2015-05-30	10.0 (7)
259	4	22	9370	2	276	anddros	2009-08-24	9.5 (13)
155	3	26	8819	2	761	vlksm	2009-04-17	9.9 (18)
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	1	1461	pegoopik	2012-07-13	10.0 (11)
234	3	4	7476	1	1481	Kursist	2020-02-28	9.5 (2)
253	3	30	7278	7	1097	$erges	2008-05-17	8.9 (20)
230	2	7	6677	1	728	pegoopik	2018-07-27	9.8 (4)
257	4	17	6467	1	2758	pegoopik	2012-02-20	9.4 (13)
161	3	22	6370	3	889	Ozzy	2009-11-06	9.3 (18)
224	3	10	6363	0	1979	selber	2017-04-14	9.4 (7)
138	5	146	6228	33	949	Cyrilus	2005-12-09	9.1 (65)
231	3	5	6186	0	787	mcrain	2018-08-24	10.0 (3)
206	4	14	6127	0	1484	Baser	2013-11-23	9.1 (12)
211	2	14	5791	1	588	Baser	2014-06-30	9.8 (9)
255	4	14	5666	3	793	vlksm	2012-02-14	9.8 (9)
225	2	10	5571	0	737	pegoopik	2017-07-15	9.8 (6)
229	3	6	5468	1	1532	al29	2018-03-23	9.6 (5)
154	4	25	4892	3	848	anddros	2009-03-18	9.9 (17)
160	3	27	4731	0	961	Ozzy	2009-08-07	9.6 (17)
159	3	17	4480	1	565	anddros	2012-07-22	8.2 (14)
220	3	6	4388	1	1175	pegoopik	2016-12-17	10.0 (3)
232	3	5	4384	0	513	al29	2018-08-20	10.0 (4)
191	3	14	4212	0	948	qwrqwr	2012-06-08	9.5 (11)
252	2	34	3918	3	308	Ozzy	2009-06-14	8.3 (23)
149	3	35	3891	2	506	$erges	2008-09-08	9.2 (21)
171	3	19	3682	1	1670	Ozzy	2010-12-05	9.3 (15)
116	5	245	3492	20	469	$erges	2008-12-13	9.4 (117)
218	4	12	3491	2	1500	al29	2016-04-04	9.6 (7)
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)
119	5	107	3203	4	703	Velmont	2014-03-07	9.6 (57)
188	3	17	3191	1	733	qwrqwr	2012-02-04	9.8 (12)
151	3	35	3190	4	1096	anddros	2008-12-30	9.0 (20)
172	3	22	3097	0	1719	Ozzy	2011-03-11	9.8 (16)
208	3	14	3063	0	821	pegoopik	2013-12-20	8.8 (12)
167	3	24	3032	0	674	qwrqwr	2011-01-18	9.9 (15)
156	2	51	3004	3	391	anddros	2009-04-17	9.1 (29)
187	3	25	2965	1	978	=Maxim=	2011-12-31	8.8 (20)
144	4	46	2928	4	950	pvv	2008-01-01	7.3 (29)
100	4	250	2919	10	650	qwrqwr	2010-04-27	9.4 (126)
153	3	37	2779	4	1539	Ozzy	2009-02-14	9.5 (20)
102	4	182	2687	8	933	GriGrim	2011-07-16	9.5 (85)
221	2	17	2539	1	1023	Baser	2016-11-05	8.9 (10)
190	4	16	2521	1	717	vlksm	2012-03-17	8.8 (13)
179	3	17	2329	0	844	pegoopik	2011-09-17	9.2 (12)
141	4	80	2225	10	977	vlksm	2006-10-29	9.0 (36)
101	4	216	2145	16	1096	pegoopik	2010-11-20	9.4 (116)
227	3	9	2137	1	2142	mcrain	2017-12-08	7.0 (5)
210	2	15	2132	0	483	_dimon_	2014-02-07	10.0 (11)
120	4	104	2008	2	239	pegoopik	2014-02-14	9.0 (51)
145	3	71	2007	1	859	pvv	2008-01-07	8.6 (33)
184	2	25	1953	2	432	Baser	2011-11-26	8.8 (19)
164	2	37	1943	1	1622	anddros	2010-04-26	9.7 (22)
148	2	66	1910	7	894	vlksm	2008-09-06	9.3 (35)
98	4	583	1900	44	538	ZrenBy	2003-09-01	8.2 (131)
205	2	16	1877	0	529	qwrqwr	2013-11-22	8.9 (10)
72	4	1016	1868	150	608	paparome	2005-12-03	9.2 (272)
193	2	22	1798	0	522	Baser	2012-07-06	8.3 (15)
150	4	37	1780	4	909	@Nikotin	2008-11-09	8.6 (21)
182	3	23	1717	0	1377	Baser	2011-10-29	8.1 (17)
87	4	635	1697	89	459	Roman Golubin	2006-07-14	9.3 (178)
222	2	13	1664	1	1475	pegoopik	2016-12-23	9.8 (8)
89	3	412	1654	32	870	_Bkmz_	2008-06-21	7.9 (157)
183	2	30	1611	2	518	GriGrim	2011-11-12	9.1 (15)
137	4	191	1607	25	616	Cyrilus	2005-03-06	9.2 (67)
146	3	61	1606	3	949	paparome	2008-01-22	9.7 (33)
223	2	12	1596	0	641	Baser	2016-11-12	9.9 (7)
200	3	19	1586	0	1129	qwrqwr	2013-10-05	9.3 (13)
175	3	30	1548	1	2151	pegoopik	2011-04-28	8.5 (22)
165	2	30	1544	3	1600	vlksm	2010-03-18	9.9 (18)
228	1	18	1540	1	1419	qwrqwr	2018-01-12	10.0 (10)
121	3	406	1529	4	804	ZrenBy	2004-02-26	7.8 (98)
196	3	25	1494	0	661	qwrqwr	2013-05-17	9.4 (15)
176	3	31	1484	0	385	qwrqwr	2011-05-20	9.5 (21)
219	2	16	1482	0	486	pegoopik	2016-04-08	9.9 (8)
136	3	114	1480	5	618	Ozzy	2011-05-12	7.5 (50)
169	3	30	1461	0	1559	Valdaj	2010-09-02	8.4 (21)
132	3	110	1446	4	2500	risp	2010-01-25	7.7 (55)
198	2	23	1444	0	332	Angellore	2013-09-13	9.4 (16)
152	3	47	1420	4	1301	vlksm	2009-01-05	9.7 (27)
180	3	32	1375	0	274	qwrqwr	2011-09-16	9.6 (24)
76	3	451	1371	16	949	silver	2010-01-23	8.8 (180)
123	3	245	1362	38	1254	Ozzy	2009-08-22	9.0 (115)
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)
158	3	38	1330	0	1174	Ozzy	2010-04-09	8.9 (23)
215	2	23	1326	0	331	pegoopik	2015-03-06	9.3 (13)
85	3	365	1324	19	1397	Ozzy	2009-10-10	8.5 (141)
135	3	65	1323	1	854	qwrqwr	2013-04-19	8.9 (34)
106	3	281	1322	6	647	vlksm	2008-11-27	8.8 (121)
212	3	16	1319	0	585	Baser	2014-10-14	8.9 (10)
168	2	43	1310	2	455	qwrqwr	2010-08-27	9.5 (25)
69	2	166	1284	7	210	Gosha	2017-12-15	9.0 (56)
82	3	386	1279	11	1780	_Virt_	2010-04-27	8.2 (142)
207	3	16	1255	0	486	pegoopik	2016-01-15	10.0 (8)
68	3	285	1242	24	608	pegoopik	2014-08-01	8.1 (111)
226	3	9	1235	2	2054	pegoopik	2017-10-14	9.2 (5)
186	1	37	1215	0	1447	Ozzy	2011-12-30	9.2 (24)
77	2	303	1211	32	1053	selber	2015-07-10	8.7 (127)
96	3	413	1200	81	572	anddros	2008-11-22	8.8 (164)
173	1	52	1172	2	945	Ozzy	2011-01-13	9.3 (28)
65	3	706	1163	47	671	Ozzy	2010-01-29	7.7 (251)
84	3	415	1161	16	815	Ozzy	2009-12-26	8.4 (152)
93	3	166	1122	5	492	qwrqwr	2014-03-14	9.3 (70)
57	1	132	1043	17	537	Kursist	2020-10-10	8.4 (40)
134	3	175	1003	4	821	pvv	2008-01-22	8.5 (71)
233	1	14	930	1	2321	pegoopik	2019-03-08	10.0 (7)
37	3	760	905	26	576	qwrqwr	2013-02-22	8.0 (258)
71	3	538	797	22	941	anddros	2009-12-26	8.3 (187)
125	3	371	735	3	526	dimzv	2004-02-29	8.7 (92)
140	2	82	720	2	578	_Bkmz_	2010-01-30	8.9 (41)
185	1	43	688	3	782	=Maxim=	2011-11-25	7.9 (25)
110	3	431	672	11	942	Snowbear	2006-03-14	8.9 (114)
195	3	26	658	0	722	Dmitrij Grinkevich	2013-04-20	9.1 (15)
126	2	185	601	12	944	$erges	2008-09-07	8.6 (91)
251	4	68	594	3	850	paparome	2006-10-01	8.0 (29)
162	2	59	592	0	1067	Ozzy	2009-12-26	9.3 (34)
58	3	612	578	12	440	qwrqwr	2013-03-01	8.1 (213)
307	2	19	553	0	1095	Baser	2017-06-29	8.5 (11)
174	1	56	535	0	1084	qwrqwr	2011-02-25	9.3 (32)
130	2	119	534	0	700	anddros	2010-05-22	8.9 (59)
99	3	196	510	8	956	Dmitrij Grinkevich	2012-05-05	8.2 (79)
202	2	29	504	0	557	qwrqwr	2013-11-01	9.1 (16)
66	3	661	463	54	392	anddros	2009-12-26	8.4 (250)
64	3	593	454	49	508	qwrqwr	2010-05-13	8.0 (187)
107	2	404	454	9	688	Fiolent	2004-02-26	8.2 (99)
254	1	45	420	1	1383	Baser	2011-09-02	8.8 (27)
127	2	60	406	2	985	GriGrim	2014-12-21	7.9 (27)
177	1	53	390	0	935	pegoopik	2011-07-17	8.5 (26)
142	2	115	379	1	944	paparome	2007-03-24	9.0 (48)
80	2	339	374	10	453	qwrqwr	2011-10-21	8.9 (138)
108	3	280	370	5	521	crescent	2011-03-23	9.0 (112)
23	3	1550	367	124	307	Palkin	2007-03-29	8.4 (377)
166	1	60	358	2	449	anddros	2010-07-26	9.5 (31)
115	2	78	348	1	736	selber	2016-05-28	9.2 (33)
170	2	54	332	1	320	qwrqwr	2010-10-24	9.0 (27)
209	1	33	319	1	735	Baser	2013-12-30	8.0 (15)
92	2	556	311	9	405	paparome	2006-07-26	8.5 (122)
45	2	440	303	16	509	dumkan	2016-04-03	7.9 (119)
139	2	126	295	2	907	Snowbear	2006-09-09	8.3 (44)
36	3	1028	275	21	786	risp	2011-05-06	8.0 (312)
111	2	453	272	3	545	Fiolent	2005-01-19	8.3 (99)
47	3	947	263	15	608	qwrqwr	2010-11-20	8.1 (288)
12	1	407	258	46	348	Serge I	2019-04-12	7.2 (100)
41	3	1115	257	17	271	qwrqwr	2010-04-26	8.1 (355)
29	2	1074	256	41	799	GiBis	2011-09-17	7.6 (339)
60	3	2055	250	120	353	Serge I	2005-03-05	7.8 (330)
54	2	1336	244	45	706	Ozzy	2008-09-06	8.1 (461)
67	2	574	232	17	729	Ozzy	2010-04-27	8.3 (204)
204	1	34	232	1	366	anddros	2013-11-19	8.7 (17)
118	2	427	231	1	206	Fiolent	2004-01-05	8.2 (90)
133	2	91	230	0	1614	pickman	2011-07-01	8.2 (47)
91	2	224	222	1	642	smog	2012-05-26	9.1 (91)
105	2	139	217	0	610	Baser	2013-09-20	8.6 (54)
34	2	1170	211	28	765	qwrqwr	2010-09-24	7.9 (354)
129	2	274	202	7	658	DimaN	2004-03-01	7.5 (59)
43	2	521	200	5	648	qwrqwr	2015-04-24	8.4 (166)
122	1	135	198	2	725	Dmitrij Grinkevich	2012-09-14	6.0 (55)
75	2	396	186	4	644	qwrqwr	2011-07-22	7.5 (145)
40	1	296	184	10	398	Serge I	2018-09-07	7.0 (81)
260	2	52	183	0	999	qwrqwr	2012-02-03	7.7 (35)
62	2	703	179	10	446	Dmitrij Grinkevich	2012-02-11	8.0 (219)
20	2	1490	179	31	327	VIG	2003-09-01	8.0 (342)
131	2	92	177	1	498	GriGrim	2012-05-25	8.6 (43)
86	2	347	176	0	433	Ozzy	2010-03-05	8.6 (117)
95	1	93	170	2	350	qwrqwr	2017-12-01	9.4 (40)
49	2	1178	170	22	862	anddros	2009-06-05	7.9 (368)
261	1	35	169	1	1495	Fomichev	2013-12-07	7.0 (19)
61	2	957	165	5	781	risp	2009-12-26	8.4 (317)
38	2	1029	163	25	302	ZrenBy	2003-09-01	7.5 (208)
59	2	909	161	6	220	VIG	2003-12-22	8.3 (199)
124	2	377	160	3	455	DimaN	2004-02-26	8.3 (87)
203	1	40	160	1	932	=Maxim=	2013-10-05	9.4 (23)
55	2	555	155	6	324	VIG	2005-06-26	7.6 (109)
304	2	24	151	0	1132	aks_nsk	2016-02-05	9.3 (15)
74	2	666	143	8	855	vlksm	2008-06-21	8.3 (203)
16	2	903	142	60	336	qwrqwr	2014-07-18	7.5 (254)
262	2	12	142	0	740	selber	2019-06-21	6.5 (6)
109	2	493	134	1	671	VIG	2003-12-23	8.0 (97)
7	1	171	127	61	513	Baser	2021-02-27	8.3 (44)
201	2	38	127	0	749	Baser	2013-09-21	8.7 (23)
303	2	11	124	0	1634	MikhailYakovlev535	2020-06-23	6.3 (7)
39	2	1373	124	24	256	Serge I	2003-08-28	7.5 (277)
78	2	415	122	4	451	_ORA_	2010-04-27	7.5 (129)
83	2	534	120	5	798	lepton	2006-09-29	8.5 (149)
236	1	9	120	0	467	Baser	2021-07-24	9.5 (6)
235	2	6	117	0	665	Kursist	2021-07-10	9.3 (3)
81	2	594	116	12	707	$erges	2008-05-10	8.3 (168)
94	2	254	114	0	773	pickman	2011-04-27	8.3 (92)
35	3	573	110	13	695	Baser	2015-09-18	8.7 (166)
51	1	555	109	15	410	Fiolent	2004-06-23	8.1 (146)
33	2	1254	108	28	364	DimaN	2004-03-01	7.6 (346)
197	1	43	107	0	518	pegoopik	2013-06-10	8.8 (19)
52	1	493	105	4	274	Serge I	2015-01-10	8.6 (143)
104	1	140	104	1	571	pegoopik	2013-07-19	8.4 (59)
128	1	229	104	4	829	inkerman	2007-09-14	8.4 (74)
79	1	965	103	14	403	Serge I	2003-06-05	7.7 (156)
44	2	734	101	7	348	Serge I	2011-11-25	7.9 (230)
305	1	25	101	0	160	Baser	2017-01-06	9.0 (14)
90	1	236	99	0	499	Dmitrij Grinkevich	2012-03-03	7.9 (84)
46	2	1192	98	126	376	Serge I	2009-08-12	6.8 (317)
70	1	670	98	3	334	Serge I	2009-04-17	7.9 (219)
73	1	456	96	3	367	Ruslan1707	2010-11-02	7.4 (150)
6	2	2012	96	79	281	Serge I	2005-05-07	7.9 (351)
17	2	1645	93	23	122	VIG	2003-04-29	8.1 (320)
113	1	135	92	0	497	smog	2013-03-29	8.5 (56)
103	1	141	86	1	850	Baser	2013-10-05	7.4 (56)
114	1	451	83	4	298	Serge I	2003-12-24	8.4 (94)
256	1	39	82	1	436	anddros	2013-11-08	8.9 (20)
24	2	1617	79	6	685	Aaz	2004-02-26	6.9 (457)
25	2	1227	77	29	232	DimaN	2004-06-22	7.1 (324)
26	1	1480	77	23	289	VIG	2003-12-22	7.7 (357)
10	1	728	75	47	179	Serge I	2017-01-20	8.0 (205)
9	2	1395	72	30	498	vasia armor	2010-05-21	8.0 (410)
28	1	1210	68	10	283	ZrenBy	2003-09-01	7.5 (233)
238	2	2	68	0	1143	Baser	2022-05-13	5.0 (1)
8	2	1480	66	94	600	Serge I	2008-06-21	7.6 (370)
21	1	1202	63	9	709	paparome	2006-03-14	8.0 (277)
97	1	368	62	3	231	dimzv	2004-03-01	7.6 (80)
112	1	38	59	2	393	Gosha	2020-06-03	9.0 (20)
32	1	1361	57	7	603	Roman Golubin	2005-12-13	7.5 (313)
42	1	1612	56	14	254	Serge I	2003-06-05	7.7 (315)
18	1	1627	55	8	157	ZrenBy	2003-09-01	7.6 (358)
117	1	429	54	0	193	Fiolent	2003-12-26	7.6 (85)
192	2	48	52	0	709	Baser	2012-03-03	9.2 (25)
27	1	1276	51	8	376	Fiolent	2004-02-26	7.3 (295)
30	1	1749	50	3	205	Serge I	2003-08-28	7.9 (389)
50	1	517	50	7	412	mslava	2003-12-23	7.2 (98)
48	1	1153	50	6	317	Serge I	2009-06-22	7.4 (304)
56	1	1047	48	3	581	Fiolent	2004-06-22	7.9 (274)
19	1	1992	47	23	269	Serge I	2004-06-23	7.5 (412)
22	1	1616	47	12	270	ZrenBy	2003-09-01	7.3 (375)
14	1	2445	47	37	116	Serge I	2003-04-08	7.5 (431)
63	1	1326	45	5	190	VIG	2003-06-05	7.6 (240)
302	0	37	45	0	510	pegoopik	2012-07-27	7.6 (11)
31	1	1043	44	6	349	Fiolent	2004-06-22	7.8 (257)
13	1	1726	39	21	194	ZrenBy	2003-09-01	7.5 (404)
53	1	1460	38	25	230	DimaN	2004-03-01	7.6 (378)
306	1	6	37	0	363	Baser	2022-04-29	7.4 (5)
15	1	1208	35	9	287	Dmitrij Grinkevich	2012-04-21	7.6 (323)
11	1	1902	34	15	130	ZrenBy	2003-09-01	7.5 (433)
88	2	20	20	1	293	Serge I	2021-10-15	9.1 (9)
258	3	25	13	0	1070	Baser	2014-09-19	7.6 (10)
301	0	43	8	0	55	pegoopik	2012-03-23	8.9 (20)
308	1	5	7	0	233	Baser	2022-05-06	6.8 (4)
237	3	1		1	1123	Baser	2022-05-13

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References