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

August 24, 20:16 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	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	2	anddros	2009-08-24	9.5 (12)
155	3	25	8819	3	vlksm	2009-04-17	10.0 (17)
216	3	11	8681	1	pegoopik	2015-05-15	9.9 (8)
194	4	14	7588	1	pegoopik	2012-07-13	10.0 (10)
253	3	30	7278	7	$erges	2008-05-17	8.9 (20)
138	5	144	6385	32	Cyrilus	2005-12-09	9.2 (64)
161	3	21	6370	2	Ozzy	2009-11-06	9.2 (17)
224	3	10	6363	0	selber	2017-04-14	9.4 (7)
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)
252	2	33	4021	3	Ozzy	2009-06-14	8.3 (22)
149	3	33	3909	2	$erges	2008-09-08	9.2 (21)
257	4	16	3753	1	pegoopik	2012-02-20	9.4 (12)
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	90	3203	5	Velmont	2014-03-07	9.7 (48)
188	3	17	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	43	2996	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	89	2611	1	pegoopik	2014-02-14	8.9 (43)
221	2	13	2539	0	Baser	2016-11-05	8.6 (8)
190	4	16	2521	1	vlksm	2012-03-17	8.8 (13)
141	4	77	2335	9	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	1	Baser	2011-11-26	8.8 (19)
72	4	971	1917	150	paparome	2005-12-03	9.2 (251)
164	2	36	1915	1	anddros	2010-04-26	9.7 (22)
148	2	64	1910	8	vlksm	2008-09-06	9.3 (35)
228	1	16	1906	1	qwrqwr	2018-01-12	10.0 (10)
98	4	561	1900	43	ZrenBy	2003-09-01	8.2 (119)
205	2	15	1877	0	qwrqwr	2013-11-22	8.9 (10)
193	2	21	1798	0	Baser	2012-07-06	8.3 (15)
87	4	608	1770	87	Roman Golubin	2006-07-14	9.3 (164)
146	3	59	1743	3	paparome	2008-01-22	9.7 (33)
89	3	389	1658	30	_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)
183	2	29	1611	2	GriGrim	2011-11-12	9.1 (15)
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)
121	3	391	1527	4	ZrenBy	2004-02-26	7.8 (90)
169	3	29	1519	0	Valdaj	2010-09-02	8.4 (21)
136	3	110	1492	5	Ozzy	2011-05-12	7.3 (47)
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	230	1445	39	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)
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	265	1362	5	vlksm	2008-11-27	8.7 (111)
213	2	25	1346	0	qwrqwr	2014-10-17	9.6 (15)
76	3	411	1344	14	silver	2010-01-23	8.8 (162)
77	2	266	1340	31	selber	2015-07-10	8.7 (111)
96	3	390	1329	81	anddros	2008-11-22	8.8 (150)
85	3	334	1266	17	Ozzy	2009-10-10	8.5 (128)
207	3	13	1255	0	pegoopik	2016-01-15	10.0 (8)
226	3	9	1235	1	pegoopik	2017-10-14	9.2 (5)
69	2	105	1223	9	Gosha	2017-12-15	9.3 (38)
186	1	36	1215	0	Ozzy	2011-12-30	9.2 (24)
82	3	349	1201	13	_Virt_	2010-04-27	8.1 (127)
68	3	234	1174	19	pegoopik	2014-08-01	8.1 (91)
173	1	51	1172	3	Ozzy	2011-01-13	9.3 (28)
65	3	638	1165	44	Ozzy	2010-01-29	7.8 (231)
168	2	41	1159	2	qwrqwr	2010-08-27	9.5 (24)
93	3	144	1134	5	qwrqwr	2014-03-14	9.3 (58)
84	3	380	1120	16	Ozzy	2009-12-26	8.3 (137)
134	3	171	1049	4	pvv	2008-01-22	8.6 (68)
37	3	609	983	24	qwrqwr	2013-02-22	8.1 (221)
140	2	80	925	2	_Bkmz_	2010-01-30	8.9 (40)
233	1	9	868	0	pegoopik	2019-03-08	10.0 (5)
71	3	492	829	19	anddros	2009-12-26	8.4 (170)
45	2	300	808	22	dumkan	2016-04-03	8.0 (86)
125	3	356	765	3	dimzv	2004-02-29	8.7 (83)
110	3	415	697	11	Snowbear	2006-03-14	8.8 (105)
195	3	25	669	0	Dmitrij Grinkevich	2013-04-20	9.1 (15)
127	2	53	642	2	GriGrim	2014-12-21	7.6 (23)
126	2	177	633	10	$erges	2008-09-07	8.5 (85)
58	3	487	632	12	qwrqwr	2013-03-01	8.2 (180)
251	4	67	594	4	paparome	2006-10-01	8.0 (28)
162	2	59	592	0	Ozzy	2009-12-26	9.3 (34)
185	1	42	583	3	=Maxim=	2011-11-25	7.9 (25)
64	3	517	576	44	qwrqwr	2010-05-13	7.9 (167)
130	2	112	541	0	anddros	2010-05-22	8.8 (55)
174	1	55	535	1	qwrqwr	2011-02-25	9.3 (32)
99	3	174	510	8	Dmitrij Grinkevich	2012-05-05	8.0 (67)
202	2	28	504	0	qwrqwr	2013-11-01	9.1 (16)
66	3	602	463	51	anddros	2009-12-26	8.4 (230)
115	2	61	436	1	selber	2016-05-28	9.1 (24)
307	2	17	421	0	Baser	2017-06-29	8.4 (10)
254	1	43	420	2	Baser	2011-09-02	8.7 (26)
107	2	388	417	9	Fiolent	2004-02-26	8.3 (90)
23	3	1382	389	119	Palkin	2007-03-29	8.3 (336)
142	2	113	388	1	paparome	2007-03-24	9.0 (47)
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	304	364	10	qwrqwr	2011-10-21	8.9 (120)
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	255	327	4	crescent	2011-03-23	8.8 (99)
36	3	878	320	19	risp	2011-05-06	7.9 (275)
209	1	32	319	1	Baser	2013-12-30	8.0 (15)
92	2	535	317	9	paparome	2006-07-26	8.4 (111)
139	2	124	310	2	Snowbear	2006-09-09	8.3 (44)
47	3	820	291	14	qwrqwr	2010-11-20	8.0 (256)
41	3	983	279	19	qwrqwr	2010-04-26	8.0 (317)
111	2	436	277	3	Fiolent	2005-01-19	8.2 (89)
60	3	1942	271	119	Serge I	2005-03-05	7.7 (297)
54	2	1211	257	44	Ozzy	2008-09-06	8.2 (426)
29	2	914	253	39	GiBis	2011-09-17	7.5 (300)
234	2	5	243	0	selber	2019-06-21	3.5 (2)
204	1	33	241	1	anddros	2013-11-19	8.7 (17)
40	1	118	238	15	Serge I	2018-09-07	7.4 (34)
118	2	411	236	1	Fiolent	2004-01-05	8.2 (80)
133	2	87	233	0	pickman	2011-07-01	8.2 (45)
34	2	1013	233	26	qwrqwr	2010-09-24	7.9 (319)
67	2	517	226	18	Ozzy	2010-04-27	8.3 (179)
105	2	122	219	0	Baser	2013-09-20	8.5 (45)
122	1	120	217	2	Dmitrij Grinkevich	2012-09-14	5.9 (47)
91	2	202	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)
43	2	383	190	2	qwrqwr	2015-04-24	8.4 (129)
75	2	353	185	4	qwrqwr	2011-07-22	7.4 (125)
49	2	1052	184	22	anddros	2009-06-05	7.8 (326)
260	2	51	183	0	qwrqwr	2012-02-03	7.7 (34)
20	2	1310	181	33	VIG	2003-09-01	7.9 (307)
16	2	697	171	59	qwrqwr	2014-07-18	7.5 (214)
62	2	590	171	8	Dmitrij Grinkevich	2012-02-11	8.0 (189)
86	2	316	169	0	Ozzy	2010-03-05	8.6 (104)
261	1	35	169	1	Fomichev	2013-12-07	7.0 (19)
61	2	844	168	5	risp	2009-12-26	8.4 (283)
124	2	362	160	3	DimaN	2004-02-26	8.3 (79)
203	1	39	160	1	=Maxim=	2013-10-05	9.4 (23)
95	1	68	152	2	qwrqwr	2017-12-01	9.3 (28)
304	2	24	151	0	aks_nsk	2016-02-05	9.3 (15)
59	2	789	149	4	VIG	2003-12-22	8.4 (169)
74	2	622	140	9	vlksm	2008-06-21	8.3 (184)
38	2	878	135	24	ZrenBy	2003-09-01	7.8 (170)
109	2	477	133	1	VIG	2003-12-23	7.9 (88)
201	2	37	127	0	Baser	2013-09-21	8.7 (23)
52	1	361	124	3	Serge I	2015-01-10	8.6 (112)
78	2	379	122	3	_ORA_	2010-04-27	7.5 (116)
83	2	500	120	4	lepton	2006-09-29	8.4 (132)
94	2	231	119	0	pickman	2011-04-27	8.2 (81)
39	2	1234	119	18	Serge I	2003-08-28	7.4 (240)
81	2	560	118	11	$erges	2008-05-10	8.2 (154)
33	2	1095	114	24	DimaN	2004-03-01	7.6 (317)
35	3	410	113	10	Baser	2015-09-18	8.7 (134)
104	1	123	108	0	pegoopik	2013-07-19	8.3 (51)
197	1	42	107	0	pegoopik	2013-06-10	8.8 (19)
44	2	603	106	4	Serge I	2011-11-25	7.9 (195)
46	2	1065	104	126	Serge I	2009-08-12	6.6 (290)
128	1	222	104	4	inkerman	2007-09-14	8.3 (70)
57	2	1729	103	14	Serge I	2005-05-07	7.8 (276)
79	1	930	103	14	Serge I	2003-06-05	7.7 (142)
90	1	213	102	0	Dmitrij Grinkevich	2012-03-03	7.8 (72)
305	1	24	101	0	Baser	2017-01-06	8.8 (13)
70	1	619	100	3	Serge I	2009-04-17	7.9 (200)
73	1	412	96	2	Ruslan1707	2010-11-02	7.4 (131)
51	1	421	94	11	Fiolent	2004-06-23	8.0 (110)
50	1	689	92	11	mslava	2003-12-22	8.4 (147)
113	1	118	91	0	smog	2013-03-29	8.4 (48)
17	2	1444	87	18	VIG	2003-04-29	8.1 (284)
103	1	123	86	1	Baser	2013-10-05	7.2 (47)
114	1	434	83	4	Serge I	2003-12-24	8.4 (86)
8	2	2058	82	101	Serge I	2003-04-08	7.8 (349)
25	2	1061	82	30	DimaN	2004-06-22	7.0 (291)
256	1	39	82	1	anddros	2013-11-08	8.9 (20)
10	1	464	79	37	Serge I	2017-01-20	8.1 (152)
24	2	1455	77	6	Aaz	2004-02-26	6.9 (421)
12	1	84	73	16	Serge I	2019-04-12	7.9 (27)
9	2	1147	72	19	vasia armor	2010-05-21	7.9 (351)
26	1	1317	72	23	VIG	2003-12-22	7.7 (329)
55	2	1259	66	73	Serge I	2008-06-21	7.5 (324)
32	1	1200	65	8	Roman Golubin	2005-12-13	7.5 (280)
28	1	1042	64	14	ZrenBy	2003-09-01	7.5 (199)
21	1	1021	64	8	paparome	2006-03-14	7.9 (241)
97	1	345	61	3	dimzv	2004-03-01	7.7 (71)
42	1	1481	57	14	Serge I	2003-06-05	7.6 (282)
117	1	413	55	0	Fiolent	2003-12-26	7.6 (76)
18	1	1444	53	5	ZrenBy	2003-09-01	7.6 (323)
48	1	1028	52	6	Serge I	2009-06-22	7.4 (271)
192	2	47	52	0	Baser	2012-03-03	9.2 (25)
27	1	1111	51	8	Fiolent	2004-02-26	7.2 (261)
30	1	1594	51	3	Serge I	2003-08-28	7.9 (354)
31	1	878	48	7	Fiolent	2004-06-22	7.8 (222)
56	1	921	48	3	Fiolent	2004-06-22	7.8 (243)
19	1	1813	47	22	Serge I	2004-06-23	7.4 (378)
14	1	2242	46	37	Serge I	2003-04-08	7.5 (392)
108	1	480	46	0	mslava	2003-12-23	7.3 (86)
22	1	1443	45	11	ZrenBy	2003-09-01	7.2 (340)
302	0	37	45	0	pegoopik	2012-07-27	7.6 (11)
7	1	2217	42	64	Serge I	2006-11-17	7.9 (411)
63	1	1213	42	5	VIG	2003-06-05	7.5 (210)
53	1	1334	41	25	DimaN	2004-03-01	7.5 (343)
13	1	1518	38	21	ZrenBy	2003-09-01	7.4 (362)
306	1	8	35	0	Serge I	2019-07-05	10.0 (5)
11	1	1679	33	14	ZrenBy	2003-09-01	7.4 (389)
15	1	1002	32	7	Dmitrij Grinkevich	2012-04-21	7.4 (287)
258	3	25	13	0	Baser	2014-09-19	7.6 (10)
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)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References