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

April 21, 02:14 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
224	3	9	19666	0	selber	2017-04-14	9.3 (6)
217	4	8	17420	4	pegoopik	2015-08-28	9.2 (5)
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	143	6386	32	Cyrilus	2005-12-09	9.2 (64)
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)
161	3	20	4787	3	Ozzy	2009-11-06	9.5 (16)
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)
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	226	3494	20	$erges	2008-12-13	9.3 (106)
218	4	11	3491	2	al29	2016-04-04	9.6 (7)
119	5	87	3203	6	Velmont	2014-03-07	9.7 (46)
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	50	3004	3	anddros	2009-04-17	9.1 (28)
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)
102	4	163	2835	6	GriGrim	2011-07-16	9.4 (74)
187	3	24	2802	0	=Maxim=	2011-12-31	8.8 (20)
153	3	35	2779	4	Ozzy	2009-02-14	9.5 (20)
120	4	85	2597	2	pegoopik	2014-02-14	8.9 (43)
221	2	13	2539	0	Baser	2016-11-05	8.6 (8)
190	4	15	2521	1	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	7	vlksm	2008-09-06	9.3 (35)
228	1	14	1906	1	qwrqwr	2018-01-12	10.0 (9)
98	4	560	1900	43	ZrenBy	2003-09-01	8.2 (119)
205	2	15	1877	0	qwrqwr	2013-11-22	8.9 (10)
72	4	959	1868	149	paparome	2005-12-03	9.2 (246)
146	3	59	1743	3	paparome	2008-01-22	9.7 (33)
87	4	604	1724	84	Roman Golubin	2006-07-14	9.3 (163)
89	3	386	1654	30	_Bkmz_	2008-06-21	7.9 (140)
137	4	187	1632	24	Cyrilus	2005-03-06	9.2 (66)
165	2	29	1631	3	vlksm	2010-03-18	9.9 (18)
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)
136	3	109	1511	5	Ozzy	2011-05-12	7.3 (47)
183	2	27	1490	4	GriGrim	2011-11-12	9.0 (14)
132	3	105	1489	4	risp	2010-01-25	7.7 (53)
121	3	386	1486	5	ZrenBy	2004-02-26	7.8 (89)
176	3	29	1484	0	qwrqwr	2011-05-20	9.5 (21)
219	2	14	1482	0	pegoopik	2016-04-08	9.9 (8)
200	3	17	1463	0	qwrqwr	2013-10-05	9.3 (12)
158	3	36	1452	0	Ozzy	2010-04-09	9.0 (22)
198	2	21	1444	0	Angellore	2013-09-13	9.4 (15)
150	4	33	1442	4	@Nikotin	2008-11-09	8.7 (19)
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)
123	3	226	1390	38	Ozzy	2009-08-22	9.0 (105)
135	3	60	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	401	1327	13	silver	2010-01-23	8.8 (157)
77	2	253	1320	32	selber	2015-07-10	8.7 (104)
207	3	12	1255	0	pegoopik	2016-01-15	10.0 (8)
85	3	328	1247	17	Ozzy	2009-10-10	8.5 (126)
226	3	8	1235	1	pegoopik	2017-10-14	9.2 (5)
69	2	90	1223	9	Gosha	2017-12-15	9.4 (35)
186	1	36	1215	0	Ozzy	2011-12-30	9.2 (24)
65	3	622	1178	42	Ozzy	2010-01-29	7.8 (225)
82	3	343	1163	10	_Virt_	2010-04-27	8.1 (124)
140	2	78	1126	2	_Bkmz_	2010-01-30	8.9 (40)
93	3	142	1122	5	qwrqwr	2014-03-14	9.3 (58)
68	3	222	1092	18	pegoopik	2014-08-01	8.2 (87)
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	581	1004	25	qwrqwr	2013-02-22	8.0 (213)
45	2	269	1003	24	dumkan	2016-04-03	8.0 (81)
168	2	40	945	1	qwrqwr	2010-08-27	9.5 (23)
173	1	50	938	2	Ozzy	2011-01-13	9.3 (28)
233	1	8	868	0	pegoopik	2019-03-08	10.0 (4)
71	3	479	756	19	anddros	2009-12-26	8.3 (166)
125	3	352	735	3	dimzv	2004-02-29	8.7 (82)
58	3	463	728	12	qwrqwr	2013-03-01	8.2 (172)
110	3	412	697	12	Snowbear	2006-03-14	8.8 (104)
195	3	25	669	0	Dmitrij Grinkevich	2013-04-20	9.1 (15)
126	2	176	627	9	$erges	2008-09-07	8.5 (84)
99	3	173	617	8	Dmitrij Grinkevich	2012-05-05	8.0 (67)
64	3	499	595	45	qwrqwr	2010-05-13	7.9 (162)
251	4	67	594	3	paparome	2006-10-01	8.0 (28)
185	1	42	583	3	=Maxim=	2011-11-25	7.9 (25)
130	2	111	559	0	anddros	2010-05-22	8.8 (55)
162	2	57	554	1	Ozzy	2009-12-26	9.3 (34)
202	2	27	504	0	qwrqwr	2013-11-01	9.2 (15)
174	1	54	489	0	qwrqwr	2011-02-25	9.3 (32)
66	3	589	477	50	anddros	2009-12-26	8.4 (227)
127	2	52	443	2	GriGrim	2014-12-21	7.5 (22)
307	2	17	421	0	Baser	2017-06-29	8.4 (10)
107	2	386	415	9	Fiolent	2004-02-26	8.3 (90)
115	2	58	405	1	selber	2016-05-28	9.1 (23)
23	3	1345	389	118	Palkin	2007-03-29	8.4 (321)
142	2	112	388	1	paparome	2007-03-24	9.0 (47)
177	1	52	372	0	pegoopik	2011-07-17	8.5 (26)
80	2	294	360	10	qwrqwr	2011-10-21	8.9 (115)
166	1	58	358	2	anddros	2010-07-26	9.6 (30)
254	1	42	349	2	Baser	2011-09-02	8.6 (25)
40	1	74	339	15	Serge I	2018-09-07	8.0 (24)
215	2	22	333	0	pegoopik	2015-03-06	9.3 (13)
170	2	53	332	1	qwrqwr	2010-10-24	9.0 (27)
139	2	123	332	2	Snowbear	2006-09-09	8.3 (44)
88	3	252	327	3	crescent	2011-03-23	8.8 (99)
209	1	31	319	1	Baser	2013-12-30	7.9 (14)
36	3	850	316	19	risp	2011-05-06	7.9 (265)
92	2	532	310	9	paparome	2006-07-26	8.4 (110)
47	3	794	299	14	qwrqwr	2010-11-20	8.0 (249)
41	3	956	281	18	qwrqwr	2010-04-26	8.0 (308)
60	3	1917	278	119	Serge I	2005-03-05	7.7 (291)
111	2	434	277	3	Fiolent	2005-01-19	8.2 (88)
54	2	1187	260	44	Ozzy	2008-09-06	8.2 (419)
29	2	880	249	40	GiBis	2011-09-17	7.5 (288)
34	2	984	239	25	qwrqwr	2010-09-24	7.9 (308)
118	2	409	239	1	Fiolent	2004-01-05	8.2 (79)
133	2	86	233	0	pickman	2011-07-01	8.2 (45)
67	2	504	232	18	Ozzy	2010-04-27	8.3 (176)
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	115	217	2	Dmitrij Grinkevich	2012-09-14	5.9 (47)
91	2	199	211	0	smog	2012-05-26	9.1 (78)
129	2	267	206	7	DimaN	2004-03-01	7.4 (55)
131	2	85	198	1	GriGrim	2012-05-25	8.5 (40)
112	2	414	195	3	VIG	2005-06-26	7.5 (73)
43	2	355	192	2	qwrqwr	2015-04-24	8.5 (122)
49	2	1026	186	22	anddros	2009-06-05	7.8 (319)
260	2	50	183	0	qwrqwr	2012-02-03	7.6 (33)
20	2	1275	182	32	VIG	2003-09-01	8.0 (292)
75	2	342	180	5	qwrqwr	2011-07-22	7.5 (120)
62	2	567	169	8	Dmitrij Grinkevich	2012-02-11	8.0 (184)
261	1	33	169	1	Fomichev	2013-12-07	6.8 (18)
61	2	820	168	5	risp	2009-12-26	8.4 (276)
86	2	310	167	0	Ozzy	2010-03-05	8.6 (102)
95	1	65	166	2	qwrqwr	2017-12-01	9.3 (28)
16	2	662	166	58	qwrqwr	2014-07-18	7.4 (203)
124	2	358	160	3	DimaN	2004-02-26	8.2 (78)
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	765	150	4	VIG	2003-12-22	8.4 (162)
74	2	612	140	8	vlksm	2008-06-21	8.3 (181)
109	2	475	134	1	VIG	2003-12-23	7.9 (88)
38	2	848	130	22	ZrenBy	2003-09-01	7.8 (161)
52	1	336	128	3	Serge I	2015-01-10	8.6 (106)
94	2	230	119	0	pickman	2011-04-27	8.2 (81)
201	2	36	119	0	Baser	2013-09-21	8.7 (22)
83	2	494	117	4	lepton	2006-09-29	8.4 (129)
81	2	549	116	13	$erges	2008-05-10	8.2 (150)
78	2	369	116	3	_ORA_	2010-04-27	7.4 (113)
39	2	1206	115	18	Serge I	2003-08-28	7.5 (234)
35	3	380	113	9	Baser	2015-09-18	8.9 (122)
33	2	1064	109	24	DimaN	2004-03-01	7.6 (309)
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	577	106	4	Serge I	2011-11-25	7.9 (191)
57	2	1705	105	14	Serge I	2005-05-07	7.7 (270)
79	1	920	104	14	Serge I	2003-06-05	7.6 (137)
128	1	221	104	4	inkerman	2007-09-14	8.3 (69)
46	2	1038	102	127	Serge I	2009-08-12	6.6 (283)
70	1	607	101	3	Serge I	2009-04-17	7.9 (195)
90	1	210	101	0	Dmitrij Grinkevich	2012-03-03	7.7 (71)
305	1	23	101	0	Baser	2017-01-06	8.8 (12)
73	1	401	97	3	Ruslan1707	2010-11-02	7.4 (126)
50	1	661	91	10	mslava	2003-12-22	8.4 (141)
113	1	116	91	0	smog	2013-03-29	8.4 (47)
51	1	394	88	8	Fiolent	2004-06-23	8.0 (104)
17	2	1410	86	19	VIG	2003-04-29	8.1 (274)
103	1	122	86	1	Baser	2013-10-05	7.2 (47)
114	1	432	83	4	Serge I	2003-12-24	8.4 (85)
10	1	418	83	37	Serge I	2017-01-20	8.1 (142)
8	2	2013	82	88	Serge I	2003-04-08	7.8 (329)
25	2	1023	79	31	DimaN	2004-06-22	7.0 (278)
24	2	1418	77	6	Aaz	2004-02-26	6.9 (407)
256	1	38	74	1	anddros	2013-11-08	8.9 (19)
9	2	1111	71	17	vasia armor	2010-05-21	7.9 (337)
26	1	1281	69	22	VIG	2003-12-22	7.8 (316)
55	2	1236	68	72	Serge I	2008-06-21	7.5 (319)
32	1	1168	66	7	Roman Golubin	2005-12-13	7.5 (269)
28	1	1009	63	11	ZrenBy	2003-09-01	7.5 (190)
21	1	984	63	8	paparome	2006-03-14	7.9 (228)
97	1	344	60	3	dimzv	2004-03-01	7.7 (71)
42	1	1455	57	14	Serge I	2003-06-05	7.6 (276)
117	1	411	55	0	Fiolent	2003-12-26	7.6 (75)
18	1	1410	52	6	ZrenBy	2003-09-01	7.5 (313)
192	2	46	52	0	Baser	2012-03-03	9.1 (24)
30	1	1561	51	3	Serge I	2003-08-28	7.8 (342)
48	1	1002	51	6	Serge I	2009-06-22	7.4 (263)
31	1	845	49	7	Fiolent	2004-06-22	7.7 (210)
27	1	1075	49	8	Fiolent	2004-02-26	7.3 (250)
56	1	897	48	4	Fiolent	2004-06-22	7.8 (236)
19	1	1777	47	23	Serge I	2004-06-23	7.4 (365)
14	1	2209	46	38	Serge I	2003-04-08	7.5 (380)
108	1	478	46	0	mslava	2003-12-23	7.3 (86)
22	1	1405	45	11	ZrenBy	2003-09-01	7.2 (325)
302	0	37	45	0	pegoopik	2012-07-27	7.6 (11)
12	1	2176	42	59	Serge I	2006-11-17	7.9 (397)
63	1	1190	42	5	VIG	2003-06-05	7.5 (202)
53	1	1311	41	25	DimaN	2004-03-01	7.5 (336)
13	1	1485	37	20	ZrenBy	2003-09-01	7.4 (353)
306	1	10	35	0	Serge I	2019-04-12	9.6 (7)
11	1	1645	33	13	ZrenBy	2003-09-01	7.4 (376)
15	1	967	32	8	Dmitrij Grinkevich	2012-04-21	7.4 (277)
301	0	43	8	0	pegoopik	2012-03-23	8.9 (20)
303	0	31	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