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

September 22, 23:44 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
  • Modelling of data
  • Visual modelling (painting)
  • Exercises voting

Forums

  • Learning stage
  • Rating stages
  • Favorites
  • Search

Certification

  • Certified professionals
  • Statistics
  • Statistics over regions (map)
  • Confirm certificate

HELP

Query optimization

For employers

Support SQL-EX.RU

Ландшафтный дизайн
Дизайн и ремонт квартир. Услуги ландшафтного дизайна и озеленения
zelmeridian.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	7	31871	3	pegoopik	2015-08-28	9.5 (4)
147	4	23	15084	1	$erges	2010-08-06	9.8 (16)
157	3	22	13065	2	anddros	2009-06-05	9.5 (13)
143	5	42	11323	15	inkerman	2007-10-07	9.0 (28)
225	2	5	10372	0	pegoopik	2017-07-15	10.0 (4)
259	4	21	9370	0	anddros	2009-08-24	9.5 (12)
155	3	23	8819	2	vlksm	2009-04-17	10.0 (15)
253	3	27	8719	8	$erges	2008-05-17	8.9 (17)
163	3	16	8342	0	Ozzy	2010-01-08	9.5 (11)
194	4	13	7588	1	pegoopik	2012-07-13	10.0 (9)
160	3	23	6522	0	Ozzy	2009-08-07	9.6 (14)
214	4	8	6392	2	pegoopik	2015-05-30	10.0 (6)
138	5	142	6385	32	Cyrilus	2005-12-09	9.1 (63)
178	3	19	5910	1	Baser	2011-08-13	8.9 (12)
181	4	13	5296	1	Ozzy	2011-10-08	9.6 (8)
161	3	18	4787	2	Ozzy	2009-11-06	9.6 (14)
211	2	11	4638	1	Baser	2014-06-30	9.7 (7)
255	4	12	4399	2	vlksm	2012-02-14	9.9 (7)
220	3	3	4388	2	pegoopik	2016-12-17	10.0 (2)
218	4	9	4365	1	al29	2016-04-04	10.0 (6)
191	3	11	4212	0	qwrqwr	2012-06-08	9.5 (8)
154	4	22	4200	3	anddros	2009-03-18	9.9 (14)
206	4	11	4162	1	Baser	2013-11-23	8.8 (9)
149	3	28	3818	2	$erges	2008-09-08	9.1 (16)
172	3	18	3717	0	Ozzy	2011-03-11	9.7 (12)
257	4	14	3710	0	pegoopik	2012-02-20	9.5 (11)
171	3	15	3682	0	Ozzy	2010-12-05	9.5 (11)
252	2	30	3569	4	Ozzy	2009-06-14	8.4 (20)
119	5	72	3523	4	Velmont	2014-03-07	9.8 (40)
116	5	213	3322	20	$erges	2008-12-13	9.3 (103)
216	3	8	3223	1	pegoopik	2015-05-15	10.0 (6)
151	3	27	3152	3	anddros	2008-12-30	9.5 (14)
208	3	11	3063	0	pegoopik	2013-12-20	8.6 (9)
167	3	19	3032	0	qwrqwr	2011-01-18	9.9 (12)
100	4	206	3019	10	qwrqwr	2010-04-27	9.4 (106)
188	3	14	3005	1	qwrqwr	2012-02-04	9.7 (10)
224	3	5	2984	0	selber	2017-04-14	9.5 (4)
189	4	11	2930	1	Baser	2012-02-05	8.4 (9)
102	4	144	2835	5	GriGrim	2011-07-16	9.4 (68)
144	4	39	2809	3	pvv	2008-01-01	7.2 (23)
156	2	44	2735	4	anddros	2009-04-17	9.1 (24)
221	2	9	2539	1	Baser	2016-11-05	9.2 (5)
207	3	7	2363	0	pegoopik	2016-01-15	10.0 (4)
223	2	7	2357	1	Baser	2016-11-12	10.0 (4)
101	4	176	2309	12	pegoopik	2010-11-20	9.4 (96)
210	2	11	2132	0	_dimon_	2014-02-07	10.0 (8)
165	2	23	2120	3	vlksm	2010-03-18	10.0 (13)
120	4	71	2008	1	pegoopik	2014-02-14	8.9 (40)
145	3	65	1999	1	pvv	2008-01-07	8.5 (30)
98	4	539	1955	45	ZrenBy	2003-09-01	8.1 (113)
164	2	29	1915	1	anddros	2010-04-26	9.8 (17)
148	2	61	1910	6	vlksm	2008-09-06	9.3 (33)
141	4	70	1897	8	vlksm	2006-10-29	8.9 (29)
72	4	930	1879	150	paparome	2005-12-03	9.2 (233)
87	4	583	1828	85	Roman Golubin	2006-07-14	9.3 (156)
153	3	29	1812	4	Ozzy	2009-02-14	9.5 (15)
193	2	17	1798	0	Baser	2012-07-06	8.2 (11)
89	3	367	1722	28	_Bkmz_	2008-06-21	7.9 (133)
205	2	12	1707	0	qwrqwr	2013-11-22	8.9 (7)
222	2	7	1664	0	pegoopik	2016-12-23	10.0 (4)
187	3	20	1658	1	=Maxim=	2011-12-31	8.6 (16)
184	2	20	1643	0	Baser	2011-11-26	9.2 (15)
179	3	14	1619	0	pegoopik	2011-09-17	9.0 (9)
137	4	186	1619	24	Cyrilus	2005-03-06	9.2 (65)
146	3	55	1606	3	paparome	2008-01-22	9.7 (30)
159	3	14	1596	0	anddros	2012-07-22	8.3 (11)
196	3	21	1529	0	qwrqwr	2013-05-17	9.4 (12)
136	3	108	1492	5	Ozzy	2011-05-12	7.4 (46)
175	3	24	1484	0	pegoopik	2011-04-28	8.4 (19)
106	3	245	1473	6	vlksm	2008-11-27	8.8 (104)
132	3	102	1472	5	risp	2010-01-25	7.8 (52)
121	3	376	1471	4	ZrenBy	2004-02-26	7.8 (89)
200	3	15	1452	0	qwrqwr	2013-10-05	9.2 (10)
307	2	7	1451	1	Baser	2017-06-29	9.0 (5)
123	3	215	1445	38	Ozzy	2009-08-22	9.0 (104)
198	2	16	1444	0	Angellore	2013-09-13	9.3 (12)
169	3	26	1443	0	Valdaj	2010-09-02	8.4 (18)
150	4	32	1442	4	@Nikotin	2008-11-09	8.6 (18)
215	2	15	1412	0	pegoopik	2015-03-06	8.9 (8)
77	2	219	1391	33	selber	2015-07-10	8.7 (93)
135	3	58	1376	1	qwrqwr	2013-04-19	9.1 (31)
180	3	26	1375	0	qwrqwr	2011-09-16	9.7 (19)
96	3	370	1366	81	anddros	2008-11-22	8.8 (145)
76	3	373	1356	13	silver	2010-01-23	8.7 (147)
199	3	15	1350	0	Baser	2013-08-17	8.3 (11)
158	3	33	1330	0	Ozzy	2010-04-09	8.9 (20)
140	2	73	1315	2	_Bkmz_	2010-01-30	8.8 (37)
176	3	26	1307	0	qwrqwr	2011-05-20	9.4 (18)
182	3	18	1288	0	Baser	2011-10-29	8.1 (14)
93	3	119	1278	5	qwrqwr	2014-03-14	9.2 (52)
85	3	308	1243	18	Ozzy	2009-10-10	8.5 (120)
190	4	13	1217	0	vlksm	2012-03-17	8.8 (10)
186	1	30	1215	0	Ozzy	2011-12-30	9.8 (18)
183	2	24	1205	3	GriGrim	2011-11-12	9.0 (12)
152	3	41	1189	4	vlksm	2009-01-05	9.7 (23)
65	3	582	1177	41	Ozzy	2010-01-29	7.7 (210)
173	1	46	1172	2	Ozzy	2011-01-13	9.5 (24)
45	2	179	1164	21	dumkan	2016-04-03	7.7 (56)
82	3	320	1163	8	_Virt_	2010-04-27	8.2 (115)
168	2	35	1159	1	qwrqwr	2010-08-27	9.6 (18)
84	3	356	1072	13	Ozzy	2009-12-26	8.3 (130)
134	3	169	1049	3	pvv	2008-01-22	8.6 (67)
51	2	277	1042	13	qwrqwr	2014-07-18	6.9 (86)
68	3	180	1030	17	pegoopik	2014-08-01	8.1 (73)
212	3	11	994	1	Baser	2014-10-14	8.8 (8)
37	3	497	983	21	qwrqwr	2013-02-22	8.2 (182)
99	3	151	949	9	Dmitrij Grinkevich	2012-05-05	7.9 (62)
71	3	454	832	19	anddros	2009-12-26	8.3 (157)
58	3	401	777	9	qwrqwr	2013-03-01	8.1 (149)
125	3	341	735	3	dimzv	2004-02-29	8.7 (82)
213	2	23	721	0	qwrqwr	2014-10-17	9.2 (13)
110	3	397	715	10	Snowbear	2006-03-14	8.9 (101)
251	4	65	634	3	paparome	2006-10-01	7.9 (27)
126	2	172	601	8	$erges	2008-09-07	8.5 (84)
195	3	21	586	0	Dmitrij Grinkevich	2013-04-20	8.9 (12)
185	1	37	583	3	=Maxim=	2011-11-25	8.2 (21)
162	2	53	554	1	Ozzy	2009-12-26	9.4 (31)
130	2	109	541	0	anddros	2010-05-22	8.8 (55)
64	3	451	513	43	qwrqwr	2010-05-13	7.8 (146)
219	3	7	461	2	pegoopik	2016-04-08	10.0 (4)
174	1	49	449	0	qwrqwr	2011-02-25	9.3 (28)
66	3	552	449	49	anddros	2009-12-26	8.4 (213)
127	2	49	443	2	GriGrim	2014-12-21	7.5 (22)
115	2	37	436	1	selber	2016-05-28	9.4 (17)
107	2	368	425	9	Fiolent	2004-02-26	8.2 (83)
166	1	55	406	2	anddros	2010-07-26	9.6 (28)
23	3	1254	403	110	Palkin	2007-03-29	8.3 (296)
202	2	23	390	0	qwrqwr	2013-11-01	9.8 (12)
142	2	108	379	1	paparome	2007-03-24	9.0 (45)
177	1	48	372	0	pegoopik	2011-07-17	8.3 (24)
80	2	268	360	11	qwrqwr	2011-10-21	9.0 (108)
88	3	231	329	2	crescent	2011-03-23	8.8 (92)
254	1	40	325	2	Baser	2011-09-02	8.6 (23)
92	2	513	323	9	paparome	2006-07-26	8.4 (105)
36	3	767	321	18	risp	2011-05-06	7.9 (238)
209	1	28	319	1	Baser	2013-12-30	8.2 (12)
170	2	50	315	1	qwrqwr	2010-10-24	9.0 (25)
139	2	119	310	2	Snowbear	2006-09-09	8.2 (42)
47	3	728	299	15	qwrqwr	2010-11-20	7.9 (227)
41	3	888	298	19	qwrqwr	2010-04-26	7.9 (284)
60	3	1861	290	119	Serge I	2005-03-05	7.7 (272)
111	2	419	280	3	Fiolent	2005-01-19	8.3 (85)
54	2	1127	260	43	Ozzy	2008-09-06	8.2 (394)
29	2	793	244	39	GiBis	2011-09-17	7.3 (256)
118	2	396	242	1	Fiolent	2004-01-05	8.2 (77)
34	2	902	239	24	qwrqwr	2010-09-24	7.9 (280)
67	2	470	233	15	Ozzy	2010-04-27	8.3 (166)
133	2	83	228	0	pickman	2011-07-01	8.2 (44)
105	2	100	224	0	Baser	2013-09-20	8.5 (39)
91	2	179	215	0	smog	2012-05-26	9.2 (71)
122	1	103	214	2	Dmitrij Grinkevich	2012-09-14	5.9 (47)
129	2	264	206	7	DimaN	2004-03-01	7.4 (55)
112	2	400	200	3	VIG	2005-06-26	7.5 (71)
43	2	275	200	2	qwrqwr	2015-04-24	8.4 (96)
131	2	83	198	1	GriGrim	2012-05-25	8.5 (40)
49	2	961	191	21	anddros	2009-06-05	7.8 (302)
260	2	49	183	0	qwrqwr	2012-02-03	7.6 (32)
204	1	27	181	1	anddros	2013-11-19	8.8 (13)
20	2	1169	179	34	VIG	2003-09-01	8.0 (263)
75	2	313	178	4	qwrqwr	2011-07-22	7.4 (111)
61	2	765	170	4	risp	2009-12-26	8.5 (255)
86	2	290	169	0	Ozzy	2010-03-05	8.6 (97)
261	1	29	165	2	Fomichev	2013-12-07	6.7 (15)
304	2	20	165	1	aks_nsk	2016-02-05	9.5 (13)
62	2	508	161	9	Dmitrij Grinkevich	2012-02-11	7.9 (167)
124	2	347	160	3	DimaN	2004-02-26	8.2 (77)
59	2	703	146	5	VIG	2003-12-22	8.5 (144)
16	2	536	146	49	qwrqwr	2014-07-18	7.4 (164)
74	2	585	143	8	vlksm	2008-06-21	8.2 (173)
203	1	33	139	1	=Maxim=	2013-10-05	9.5 (18)
109	2	457	138	1	VIG	2003-12-23	8.0 (83)
52	1	256	137	4	Serge I	2015-01-10	8.5 (85)
83	2	472	120	4	lepton	2006-09-29	8.4 (119)
94	2	209	120	1	pickman	2011-04-27	8.3 (75)
81	2	524	119	12	$erges	2008-05-10	8.1 (141)
38	2	770	118	21	ZrenBy	2003-09-01	7.8 (141)
78	2	343	115	3	_ORA_	2010-04-27	7.4 (106)
57	2	1645	112	15	Serge I	2005-05-07	7.7 (254)
35	3	278	111	5	Baser	2015-09-18	9.0 (88)
39	2	1134	109	16	Serge I	2003-08-28	7.4 (212)
201	2	33	109	0	Baser	2013-09-21	8.7 (20)
197	1	39	107	0	pegoopik	2013-06-10	8.7 (16)
33	2	978	107	26	DimaN	2004-03-01	7.6 (283)
46	2	974	106	126	Serge I	2009-08-12	6.5 (265)
128	1	218	106	4	inkerman	2007-09-14	8.3 (69)
79	1	896	104	13	Serge I	2003-06-05	7.6 (130)
70	1	582	103	3	Serge I	2009-04-17	7.8 (188)
90	1	190	102	0	Dmitrij Grinkevich	2012-03-03	7.7 (66)
104	1	102	101	1	pegoopik	2013-07-19	8.3 (45)
305	1	17	101	1	Baser	2017-01-06	8.6 (9)
73	1	373	98	2	Ruslan1707	2010-11-02	7.2 (117)
44	2	506	97	4	Serge I	2011-11-25	8.0 (165)
103	1	102	95	1	Baser	2013-10-05	7.1 (42)
113	1	100	93	0	smog	2013-03-29	8.4 (44)
114	1	418	86	4	Serge I	2003-12-24	8.4 (82)
69	1	579	86	1	mslava	2003-12-22	8.3 (119)
40	2	1913	84	74	Serge I	2003-04-08	7.7 (284)
50	2	1277	80	8	VIG	2003-04-29	8.2 (241)
24	2	1330	76	7	Aaz	2004-02-26	6.8 (384)
25	2	936	76	28	DimaN	2004-06-22	6.9 (256)
10	1	202	71	21	Serge I	2017-01-20	8.1 (80)
95	1	290	70	0	Fiolent	2004-06-23	8.0 (72)
17	2	957	69	4	vasia armor	2010-05-21	7.8 (274)
55	2	1176	69	72	Serge I	2008-06-21	7.5 (301)
26	1	1195	67	22	VIG	2003-12-22	7.7 (296)
32	1	1085	66	8	Roman Golubin	2005-12-13	7.5 (248)
256	1	35	60	1	anddros	2013-11-08	9.1 (17)
42	1	1387	59	15	Serge I	2003-06-05	7.5 (256)
21	1	883	59	6	paparome	2006-03-14	7.9 (207)
97	1	322	58	4	dimzv	2004-03-01	7.7 (66)
28	1	920	57	13	ZrenBy	2003-09-01	7.5 (168)
117	1	398	56	0	Fiolent	2003-12-26	7.6 (74)
192	2	43	52	0	Baser	2012-03-03	9.2 (22)
30	1	1479	50	3	Serge I	2003-08-28	7.7 (314)
18	1	1302	50	6	ZrenBy	2003-09-01	7.5 (285)
48	1	936	50	6	Serge I	2009-06-22	7.3 (248)
56	1	838	48	3	Fiolent	2004-06-22	7.8 (219)
19	1	1676	47	19	Serge I	2004-06-23	7.4 (341)
31	1	758	47	6	Fiolent	2004-06-22	7.7 (183)
27	1	989	46	8	Fiolent	2004-02-26	7.2 (229)
14	1	2090	45	35	Serge I	2003-04-08	7.4 (347)
108	1	460	45	0	mslava	2003-12-23	7.4 (80)
22	1	1310	44	9	ZrenBy	2003-09-01	7.1 (302)
12	1	2050	43	59	Serge I	2006-11-17	7.8 (358)
63	1	1132	42	5	VIG	2003-06-05	7.5 (185)
53	1	1248	42	25	DimaN	2004-03-01	7.4 (318)
302	0	34	36	0	pegoopik	2012-07-27	7.8 (9)
13	1	1358	35	19	ZrenBy	2003-09-01	7.3 (318)
11	1	1514	33	10	ZrenBy	2003-09-01	7.3 (337)
15	1	841	31	6	Dmitrij Grinkevich	2012-04-21	7.3 (243)
306	1	10	27	0	Serge I	2017-07-14	9.6 (7)
303	0	28	7	0	Serge I	2013-06-28	9.7 (13)
301	0	40	7	0	pegoopik	2012-03-23	8.9 (19)
258	3	21	3	1	Baser	2014-09-19	7.4 (7)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References