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

June 16, 07:18 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

  • 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

Ландшафтный дизайн
Дизайн и ремонт квартир. Услуги ландшафтного дизайна и озеленения
zelmeridian.ru
Звоните 7(495) 660-92-90 пластика груди
lantanclinic.ru
Vzp
vzp
petrocontrol.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);
Rank - average score on a result of voting.

No	Bonus	Solved	Time(min)	noOK	Author	Date	Rank
217	4	9	31871	3	pegoopik	2015-08-28	9.2 (5)
224	3	9	19666	0	selber	2017-04-14	9.3 (6)
147	4	25	15084	2	$erges	2010-08-06	9.7 (18)
157	3	23	13065	2	anddros	2009-06-05	9.6 (14)
163	3	19	11408	0	Ozzy	2010-01-08	9.6 (14)
143	5	43	11333	14	inkerman	2007-10-07	9.0 (28)
214	4	10	9964	0	pegoopik	2015-05-30	10.0 (6)
259	4	21	9370	1	anddros	2009-08-24	9.5 (12)
155	3	25	8819	3	vlksm	2009-04-17	10.0 (17)
253	3	29	8719	7	$erges	2008-05-17	8.9 (19)
216	3	11	8681	1	pegoopik	2015-05-15	9.9 (8)
194	4	14	7588	1	pegoopik	2012-07-13	10.0 (10)
138	5	144	6385	32	Cyrilus	2005-12-09	9.2 (64)
161	3	21	6370	2	Ozzy	2009-11-06	9.2 (17)
231	3	5	6186	0	mcrain	2018-08-24	10.0 (3)
206	4	14	6127	0	Baser	2013-11-23	9.1 (12)
225	2	9	6053	0	pegoopik	2017-07-15	9.8 (6)
211	2	13	5791	1	Baser	2014-06-30	9.8 (9)
230	2	6	5717	0	pegoopik	2018-07-27	9.8 (4)
255	4	13	5666	4	vlksm	2012-02-14	9.9 (8)
229	3	6	5468	1	al29	2018-03-23	9.6 (5)
181	4	14	5296	1	Ozzy	2011-10-08	9.7 (9)
160	3	26	4731	0	Ozzy	2009-08-07	9.6 (17)
220	3	6	4388	1	pegoopik	2016-12-17	10.0 (3)
232	3	5	4384	0	al29	2018-08-20	10.0 (4)
191	3	14	4212	0	qwrqwr	2012-06-08	9.5 (11)
154	4	24	4200	3	anddros	2009-03-18	9.9 (16)
228	1	15	3973	1	qwrqwr	2018-01-12	10.0 (9)
252	2	32	3918	3	Ozzy	2009-06-14	8.3 (21)
149	3	33	3909	2	$erges	2008-09-08	9.2 (21)
257	4	15	3753	1	pegoopik	2012-02-20	9.5 (11)
172	3	21	3717	0	Ozzy	2011-03-11	9.7 (15)
171	3	19	3682	1	Ozzy	2010-12-05	9.3 (15)
116	5	228	3494	20	$erges	2008-12-13	9.3 (107)
218	4	12	3491	2	al29	2016-04-04	9.6 (7)
119	5	89	3203	6	Velmont	2014-03-07	9.7 (47)
188	3	16	3191	1	qwrqwr	2012-02-04	9.8 (12)
151	3	32	3152	5	anddros	2008-12-30	8.9 (19)
189	4	14	3087	0	Baser	2012-02-05	8.5 (11)
159	3	16	3082	0	anddros	2012-07-22	8.1 (13)
208	3	14	3063	0	pegoopik	2013-12-20	8.8 (12)
156	2	51	3004	3	anddros	2009-04-17	9.1 (29)
144	4	42	2928	4	pvv	2008-01-01	7.2 (26)
100	4	228	2916	9	qwrqwr	2010-04-27	9.4 (112)
167	3	22	2887	0	qwrqwr	2011-01-18	9.9 (15)
187	3	24	2802	0	=Maxim=	2011-12-31	8.8 (20)
102	4	164	2786	6	GriGrim	2011-07-16	9.4 (74)
153	3	35	2779	4	Ozzy	2009-02-14	9.5 (20)
120	4	88	2611	1	pegoopik	2014-02-14	8.9 (43)
221	2	13	2539	0	Baser	2016-11-05	8.6 (8)
190	4	15	2521	2	vlksm	2012-03-17	8.8 (12)
141	4	77	2335	8	vlksm	2006-10-29	9.0 (35)
179	3	17	2329	0	pegoopik	2011-09-17	9.2 (12)
178	3	22	2268	1	Baser	2011-08-13	9.1 (15)
227	3	9	2137	1	mcrain	2017-12-08	7.0 (5)
210	2	14	2132	0	_dimon_	2014-02-07	10.0 (11)
101	4	196	2125	14	pegoopik	2010-11-20	9.4 (103)
145	3	68	2007	1	pvv	2008-01-07	8.6 (33)
184	2	25	1953	0	Baser	2011-11-26	8.8 (19)
164	2	36	1915	1	anddros	2010-04-26	9.7 (22)
148	2	64	1910	8	vlksm	2008-09-06	9.3 (35)
98	4	560	1900	43	ZrenBy	2003-09-01	8.2 (119)
72	4	964	1879	150	paparome	2005-12-03	9.2 (249)
205	2	15	1877	0	qwrqwr	2013-11-22	8.9 (10)
146	3	59	1743	3	paparome	2008-01-22	9.7 (33)
87	4	605	1724	86	Roman Golubin	2006-07-14	9.3 (163)
89	3	388	1654	29	_Bkmz_	2008-06-21	7.8 (141)
165	2	29	1631	3	vlksm	2010-03-18	9.9 (18)
137	4	188	1619	24	Cyrilus	2005-03-06	9.2 (66)
223	2	11	1596	1	Baser	2016-11-12	9.7 (7)
222	2	11	1583	1	pegoopik	2016-12-23	9.8 (8)
182	3	22	1566	0	Baser	2011-10-29	8.1 (17)
175	3	29	1548	0	pegoopik	2011-04-28	8.5 (22)
196	3	23	1529	0	qwrqwr	2013-05-17	9.4 (14)
169	3	29	1519	0	Valdaj	2010-09-02	8.4 (21)
121	3	389	1502	4	ZrenBy	2004-02-26	7.8 (89)
136	3	110	1492	5	Ozzy	2011-05-12	7.3 (47)
183	2	28	1490	3	GriGrim	2011-11-12	9.0 (14)
176	3	29	1484	0	qwrqwr	2011-05-20	9.5 (21)
219	2	14	1482	0	pegoopik	2016-04-08	9.9 (8)
132	3	106	1472	4	risp	2010-01-25	7.7 (53)
200	3	17	1463	0	qwrqwr	2013-10-05	9.3 (12)
158	3	36	1452	0	Ozzy	2010-04-09	9.0 (22)
123	3	229	1445	38	Ozzy	2009-08-22	9.0 (106)
198	2	21	1444	0	Angellore	2013-09-13	9.4 (15)
150	4	34	1442	4	@Nikotin	2008-11-09	8.5 (20)
152	3	44	1420	4	vlksm	2009-01-05	9.7 (26)
193	2	20	1412	0	Baser	2012-07-06	8.1 (14)
212	3	15	1403	0	Baser	2014-10-14	8.8 (10)
135	3	61	1376	1	qwrqwr	2013-04-19	8.9 (33)
180	3	29	1375	0	qwrqwr	2011-09-16	9.6 (22)
199	3	18	1371	0	Baser	2013-08-17	8.3 (13)
106	3	264	1362	5	vlksm	2008-11-27	8.7 (111)
213	2	25	1346	0	qwrqwr	2014-10-17	9.6 (15)
96	3	389	1340	81	anddros	2008-11-22	8.8 (150)
76	3	405	1340	13	silver	2010-01-23	8.8 (160)
77	2	259	1340	31	selber	2015-07-10	8.8 (107)
85	3	330	1260	15	Ozzy	2009-10-10	8.5 (126)
207	3	12	1255	0	pegoopik	2016-01-15	10.0 (8)
69	2	97	1246	7	Gosha	2017-12-15	9.3 (37)
226	3	8	1235	1	pegoopik	2017-10-14	9.2 (5)
186	1	36	1215	0	Ozzy	2011-12-30	9.2 (24)
65	3	627	1180	42	Ozzy	2010-01-29	7.8 (227)
173	1	51	1172	3	Ozzy	2011-01-13	9.3 (28)
82	3	344	1163	12	_Virt_	2010-04-27	8.1 (124)
68	3	225	1123	18	pegoopik	2014-08-01	8.2 (88)
93	3	142	1122	5	qwrqwr	2014-03-14	9.3 (58)
134	3	171	1049	4	pvv	2008-01-22	8.6 (68)
84	3	374	1008	16	Ozzy	2009-12-26	8.3 (135)
37	3	591	960	25	qwrqwr	2013-02-22	8.1 (215)
45	2	280	949	21	dumkan	2016-04-03	8.0 (83)
168	2	40	945	2	qwrqwr	2010-08-27	9.5 (23)
140	2	80	925	2	_Bkmz_	2010-01-30	8.9 (40)
233	1	8	868	0	pegoopik	2019-03-08	10.0 (4)
71	3	485	805	18	anddros	2009-12-26	8.3 (168)
125	3	355	784	3	dimzv	2004-02-29	8.7 (83)
58	3	469	728	12	qwrqwr	2013-03-01	8.2 (175)
110	3	414	697	11	Snowbear	2006-03-14	8.8 (105)
195	3	25	669	0	Dmitrij Grinkevich	2013-04-20	9.1 (15)
126	2	176	627	10	$erges	2008-09-07	8.5 (84)
99	3	173	617	8	Dmitrij Grinkevich	2012-05-05	8.0 (67)
251	4	67	594	3	paparome	2006-10-01	8.0 (28)
185	1	42	583	3	=Maxim=	2011-11-25	7.9 (25)
64	3	504	577	44	qwrqwr	2010-05-13	7.9 (163)
162	2	58	554	1	Ozzy	2009-12-26	9.3 (34)
130	2	112	541	0	anddros	2010-05-22	8.8 (55)
174	1	55	535	1	qwrqwr	2011-02-25	9.3 (32)
202	2	27	504	0	qwrqwr	2013-11-01	9.2 (15)
66	3	590	463	53	anddros	2009-12-26	8.4 (227)
127	2	52	443	2	GriGrim	2014-12-21	7.5 (22)
115	2	60	436	1	selber	2016-05-28	9.1 (24)
307	2	17	421	0	Baser	2017-06-29	8.4 (10)
107	2	387	417	9	Fiolent	2004-02-26	8.3 (90)
142	2	113	388	1	paparome	2007-03-24	9.0 (47)
23	3	1360	387	118	Palkin	2007-03-29	8.3 (327)
166	1	59	375	2	anddros	2010-07-26	9.6 (30)
177	1	52	372	0	pegoopik	2011-07-17	8.5 (26)
80	2	297	364	11	qwrqwr	2011-10-21	9.0 (117)
254	1	42	349	2	Baser	2011-09-02	8.6 (25)
40	1	93	339	15	Serge I	2018-09-07	7.7 (26)
215	2	22	333	0	pegoopik	2015-03-06	9.3 (13)
170	2	53	332	1	qwrqwr	2010-10-24	9.0 (27)
88	3	253	327	3	crescent	2011-03-23	8.8 (99)
209	1	31	319	1	Baser	2013-12-30	7.9 (14)
36	3	860	315	19	risp	2011-05-06	7.9 (267)
92	2	532	310	10	paparome	2006-07-26	8.4 (110)
139	2	124	310	2	Snowbear	2006-09-09	8.3 (44)
47	3	801	296	14	qwrqwr	2010-11-20	8.0 (251)
41	3	963	280	18	qwrqwr	2010-04-26	8.0 (311)
60	3	1923	278	119	Serge I	2005-03-05	7.7 (293)
111	2	436	277	3	Fiolent	2005-01-19	8.2 (89)
54	2	1192	258	45	Ozzy	2008-09-06	8.2 (421)
29	2	893	249	40	GiBis	2011-09-17	7.5 (291)
34	2	994	237	25	qwrqwr	2010-09-24	7.9 (311)
118	2	411	236	1	Fiolent	2004-01-05	8.2 (80)
133	2	87	233	0	pickman	2011-07-01	8.2 (45)
67	2	506	232	17	Ozzy	2010-04-27	8.3 (177)
204	1	32	232	1	anddros	2013-11-19	8.6 (16)
105	2	121	224	0	Baser	2013-09-20	8.5 (45)
122	1	118	214	2	Dmitrij Grinkevich	2012-09-14	5.9 (47)
91	2	201	211	0	smog	2012-05-26	9.2 (79)
129	2	267	206	7	DimaN	2004-03-01	7.4 (55)
112	2	416	195	3	VIG	2005-06-26	7.5 (74)
131	2	86	192	1	GriGrim	2012-05-25	8.5 (40)
49	2	1032	186	22	anddros	2009-06-05	7.8 (321)
75	2	346	185	4	qwrqwr	2011-07-22	7.5 (123)
260	2	50	183	0	qwrqwr	2012-02-03	7.6 (33)
20	2	1288	181	33	VIG	2003-09-01	8.0 (299)
43	2	363	175	3	qwrqwr	2015-04-24	8.5 (123)
16	2	675	174	61	qwrqwr	2014-07-18	7.5 (207)
62	2	573	169	8	Dmitrij Grinkevich	2012-02-11	7.9 (185)
261	1	33	169	1	Fomichev	2013-12-07	6.8 (18)
61	2	826	168	5	risp	2009-12-26	8.5 (278)
86	2	312	168	0	Ozzy	2010-03-05	8.6 (102)
95	1	66	162	2	qwrqwr	2017-12-01	9.3 (28)
124	2	361	160	3	DimaN	2004-02-26	8.3 (79)
203	1	39	160	1	=Maxim=	2013-10-05	9.4 (23)
304	2	24	151	0	aks_nsk	2016-02-05	9.3 (15)
59	2	771	150	4	VIG	2003-12-22	8.5 (164)
74	2	615	142	8	vlksm	2008-06-21	8.3 (182)
109	2	476	133	1	VIG	2003-12-23	7.9 (88)
38	2	860	131	23	ZrenBy	2003-09-01	7.8 (163)
52	1	343	124	3	Serge I	2015-01-10	8.7 (108)
94	2	230	119	0	pickman	2011-04-27	8.2 (81)
83	2	495	119	4	lepton	2006-09-29	8.4 (129)
201	2	36	119	0	Baser	2013-09-21	8.7 (22)
81	2	553	118	12	$erges	2008-05-10	8.2 (152)
78	2	373	117	3	_ORA_	2010-04-27	7.4 (115)
39	2	1214	116	20	Serge I	2003-08-28	7.5 (236)
35	3	392	113	9	Baser	2015-09-18	8.9 (125)
33	2	1074	109	24	DimaN	2004-03-01	7.6 (310)
104	1	122	108	0	pegoopik	2013-07-19	8.3 (51)
197	1	42	107	0	pegoopik	2013-06-10	8.8 (19)
44	2	583	106	4	Serge I	2011-11-25	7.9 (192)
79	1	924	104	14	Serge I	2003-06-05	7.6 (139)
57	2	1711	104	14	Serge I	2005-05-07	7.8 (272)
128	1	221	104	4	inkerman	2007-09-14	8.3 (69)
46	2	1046	103	126	Serge I	2009-08-12	6.6 (285)
90	1	212	102	0	Dmitrij Grinkevich	2012-03-03	7.8 (72)
70	1	611	101	3	Serge I	2009-04-17	7.9 (197)
305	1	23	101	0	Baser	2017-01-06	8.8 (12)
73	1	404	97	3	Ruslan1707	2010-11-02	7.4 (128)
50	1	669	91	10	mslava	2003-12-22	8.4 (143)
51	1	403	91	9	Fiolent	2004-06-23	8.0 (107)
113	1	118	91	0	smog	2013-03-29	8.4 (48)
103	1	122	86	1	Baser	2013-10-05	7.2 (47)
17	2	1422	86	20	VIG	2003-04-29	8.1 (279)
8	2	2036	83	92	Serge I	2003-04-08	7.8 (336)
10	1	437	83	38	Serge I	2017-01-20	8.1 (146)
114	1	434	83	4	Serge I	2003-12-24	8.4 (86)
25	2	1039	80	30	DimaN	2004-06-22	7.0 (283)
24	2	1433	77	6	Aaz	2004-02-26	6.8 (413)
256	1	38	74	1	anddros	2013-11-08	8.9 (19)
9	2	1127	71	19	vasia armor	2010-05-21	7.9 (341)
26	1	1296	70	23	VIG	2003-12-22	7.7 (320)
55	2	1241	67	72	Serge I	2008-06-21	7.5 (320)
32	1	1178	65	8	Roman Golubin	2005-12-13	7.5 (271)
28	1	1022	63	13	ZrenBy	2003-09-01	7.5 (192)
21	1	998	63	8	paparome	2006-03-14	7.9 (234)
97	1	344	60	3	dimzv	2004-03-01	7.7 (71)
42	1	1462	57	14	Serge I	2003-06-05	7.6 (278)
117	1	413	55	0	Fiolent	2003-12-26	7.6 (76)
18	1	1423	53	5	ZrenBy	2003-09-01	7.5 (317)
192	2	46	52	0	Baser	2012-03-03	9.1 (24)
30	1	1572	51	3	Serge I	2003-08-28	7.8 (345)
48	1	1008	51	6	Serge I	2009-06-22	7.4 (265)
27	1	1090	50	8	Fiolent	2004-02-26	7.2 (254)
31	1	856	49	7	Fiolent	2004-06-22	7.7 (213)
56	1	903	48	3	Fiolent	2004-06-22	7.8 (239)
19	1	1791	47	23	Serge I	2004-06-23	7.4 (371)
14	1	2224	46	37	Serge I	2003-04-08	7.5 (385)
108	1	479	46	0	mslava	2003-12-23	7.3 (86)
22	1	1419	45	11	ZrenBy	2003-09-01	7.2 (332)
302	0	37	45	0	pegoopik	2012-07-27	7.6 (11)
12	1	2190	42	59	Serge I	2006-11-17	7.9 (401)
63	1	1196	42	5	VIG	2003-06-05	7.5 (204)
53	1	1316	41	25	DimaN	2004-03-01	7.5 (338)
13	1	1499	38	20	ZrenBy	2003-09-01	7.4 (357)
306	1	12	34	0	Serge I	2019-04-12	9.6 (7)
15	1	982	33	8	Dmitrij Grinkevich	2012-04-21	7.4 (281)
11	1	1659	33	14	ZrenBy	2003-09-01	7.4 (380)
301	0	43	8	0	pegoopik	2012-03-23	8.9 (20)
303	0	32	7	0	Serge I	2013-06-28	9.5 (14)
258	3	24	4	0	Baser	2014-09-19	7.3 (9)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References