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

June 24, 04:51 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
Звоните 7(495) 660-92-90 пластика груди
lantanclinic.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	3	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)
143	5	43	11333	14	inkerman	2007-10-07	9.0 (28)
163	3	18	10318	0	Ozzy	2010-01-08	9.6 (13)
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	2	vlksm	2009-04-17	10.0 (17)
253	3	29	8719	7	$erges	2008-05-17	8.9 (19)
216	3	10	8681	1	pegoopik	2015-05-15	10.0 (7)
194	4	14	7588	1	pegoopik	2012-07-13	10.0 (10)
138	5	143	6386	32	Cyrilus	2005-12-09	9.2 (64)
206	4	13	6127	0	Baser	2013-11-23	9.0 (11)
225	2	8	6053	0	pegoopik	2017-07-15	9.8 (5)
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	2	Ozzy	2009-11-06	9.5 (16)
160	3	24	4731	0	Ozzy	2009-08-07	9.7 (15)
211	2	11	4638	2	Baser	2014-06-30	9.7 (7)
255	4	12	4399	4	vlksm	2012-02-14	9.9 (7)
220	3	5	4388	1	pegoopik	2016-12-17	10.0 (2)
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	31	3818	2	$erges	2008-09-08	9.1 (19)
172	3	20	3717	0	Ozzy	2011-03-11	9.7 (14)
257	4	14	3710	1	pegoopik	2012-02-20	9.5 (11)
218	4	11	3491	1	al29	2016-04-04	9.6 (7)
116	5	218	3479	19	$erges	2008-12-13	9.3 (103)
119	5	80	3365	3	Velmont	2014-03-07	9.7 (43)
178	3	21	3302	1	Baser	2011-08-13	9.0 (14)
188	3	15	3191	1	qwrqwr	2012-02-04	9.7 (11)
171	3	18	3174	1	Ozzy	2010-12-05	9.3 (14)
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	13	3063	0	pegoopik	2013-12-20	8.6 (11)
167	3	21	3032	0	qwrqwr	2011-01-18	9.9 (14)
151	3	29	3014	5	anddros	2008-12-30	9.1 (16)
156	2	50	3004	3	anddros	2009-04-17	9.1 (28)
100	4	218	2980	10	qwrqwr	2010-04-27	9.4 (109)
144	4	41	2928	3	pvv	2008-01-01	7.3 (25)
102	4	154	2835	6	GriGrim	2011-07-16	9.4 (70)
120	4	79	2578	1	pegoopik	2014-02-14	8.9 (42)
221	2	13	2539	0	Baser	2016-11-05	8.6 (8)
190	4	15	2521	1	vlksm	2012-03-17	8.8 (12)
153	3	33	2481	5	Ozzy	2009-02-14	9.4 (18)
141	4	74	2141	8	vlksm	2006-10-29	9.0 (33)
227	3	9	2137	0	mcrain	2017-12-08	7.0 (5)
210	2	13	2132	0	_dimon_	2014-02-07	10.0 (10)
101	4	186	2125	14	pegoopik	2010-11-20	9.4 (99)
145	3	67	2007	1	pvv	2008-01-07	8.6 (32)
98	4	551	1930	44	ZrenBy	2003-09-01	8.1 (117)
148	2	63	1910	7	vlksm	2008-09-06	9.3 (35)
72	4	949	1879	149	paparome	2005-12-03	9.2 (243)
205	2	13	1877	0	qwrqwr	2013-11-22	8.6 (8)
87	4	595	1825	84	Roman Golubin	2006-07-14	9.3 (159)
193	2	19	1798	0	Baser	2012-07-06	8.0 (13)
89	3	378	1722	29	_Bkmz_	2008-06-21	7.9 (137)
182	3	21	1717	0	Baser	2011-10-29	8.1 (16)
187	3	22	1686	1	=Maxim=	2011-12-31	8.6 (18)
164	2	33	1672	2	anddros	2010-04-26	9.7 (20)
184	2	24	1643	0	Baser	2011-11-26	9.0 (18)
137	4	187	1632	24	Cyrilus	2005-03-06	9.2 (66)
165	2	27	1631	3	vlksm	2010-03-18	10.0 (16)
179	3	16	1619	1	pegoopik	2011-09-17	9.1 (11)
146	3	58	1606	3	paparome	2008-01-22	9.7 (32)
223	2	11	1596	1	Baser	2016-11-12	9.7 (7)
222	2	11	1583	0	pegoopik	2016-12-23	9.8 (8)
196	3	22	1529	0	qwrqwr	2013-05-17	9.5 (13)
136	3	109	1511	5	Ozzy	2011-05-12	7.3 (47)
183	2	27	1490	3	GriGrim	2011-11-12	9.0 (14)
132	3	103	1489	4	risp	2010-01-25	7.7 (53)
175	3	28	1484	0	pegoopik	2011-04-28	8.5 (21)
121	3	382	1478	4	ZrenBy	2004-02-26	7.8 (89)
169	3	28	1461	0	Valdaj	2010-09-02	8.5 (20)
158	3	36	1452	0	Ozzy	2010-04-09	9.0 (22)
200	3	16	1452	0	qwrqwr	2013-10-05	9.3 (11)
150	4	33	1442	4	@Nikotin	2008-11-09	8.7 (19)
198	2	18	1440	0	Angellore	2013-09-13	9.3 (13)
152	3	44	1420	4	vlksm	2009-01-05	9.7 (26)
123	3	221	1405	38	Ozzy	2009-08-22	9.0 (105)
135	3	60	1376	1	qwrqwr	2013-04-19	8.9 (33)
180	3	28	1375	0	qwrqwr	2011-09-16	9.6 (21)
199	3	17	1371	0	Baser	2013-08-17	8.4 (12)
77	2	236	1370	33	selber	2015-07-10	8.7 (100)
228	1	12	1363	1	qwrqwr	2018-01-12	10.0 (8)
96	3	380	1354	81	anddros	2008-11-22	8.8 (148)
176	3	28	1341	0	qwrqwr	2011-05-20	9.5 (20)
76	3	389	1340	13	silver	2010-01-23	8.8 (155)
106	3	253	1322	6	vlksm	2008-11-27	8.8 (106)
212	3	14	1319	0	Baser	2014-10-14	8.8 (9)
93	3	133	1278	5	qwrqwr	2014-03-14	9.3 (57)
207	3	11	1255	0	pegoopik	2016-01-15	10.0 (7)
85	3	318	1247	17	Ozzy	2009-10-10	8.4 (123)
226	3	8	1235	1	pegoopik	2017-10-14	9.2 (5)
186	1	33	1215	0	Ozzy	2011-12-30	9.8 (21)
69	2	60	1208	7	Gosha	2017-12-15	9.4 (28)
82	3	333	1201	9	_Virt_	2010-04-27	8.3 (121)
65	3	599	1178	40	Ozzy	2010-01-29	7.7 (218)
173	1	49	1172	2	Ozzy	2011-01-13	9.3 (27)
45	2	218	1164	21	dumkan	2016-04-03	7.9 (68)
140	2	78	1126	2	_Bkmz_	2010-01-30	8.9 (40)
68	3	202	1092	17	pegoopik	2014-08-01	8.2 (82)
134	3	170	1049	3	pvv	2008-01-22	8.6 (68)
84	3	364	1008	16	Ozzy	2009-12-26	8.4 (132)
37	3	534	955	24	qwrqwr	2013-02-22	8.1 (197)
168	2	38	945	1	qwrqwr	2010-08-27	9.5 (21)
99	3	164	943	8	Dmitrij Grinkevich	2012-05-05	7.9 (64)
71	3	469	797	18	anddros	2009-12-26	8.3 (164)
125	3	347	735	3	dimzv	2004-02-29	8.7 (82)
213	2	24	721	0	qwrqwr	2014-10-17	9.1 (14)
58	3	429	719	11	qwrqwr	2013-03-01	8.1 (161)
110	3	403	715	10	Snowbear	2006-03-14	8.9 (101)
126	2	174	627	8	$erges	2008-09-07	8.5 (84)
251	4	66	594	3	paparome	2006-10-01	7.9 (27)
195	3	22	586	0	Dmitrij Grinkevich	2013-04-20	9.0 (13)
185	1	39	583	3	=Maxim=	2011-11-25	8.2 (23)
219	3	12	575	1	pegoopik	2016-04-08	9.9 (7)
162	2	55	554	1	Ozzy	2009-12-26	9.3 (33)
130	2	109	541	1	anddros	2010-05-22	8.8 (55)
64	3	470	513	44	qwrqwr	2010-05-13	7.8 (152)
66	3	567	477	49	anddros	2009-12-26	8.4 (217)
174	1	52	449	0	qwrqwr	2011-02-25	9.2 (31)
127	2	50	443	2	GriGrim	2014-12-21	7.5 (22)
107	2	376	425	9	Fiolent	2004-02-26	8.3 (86)
115	2	46	405	1	selber	2016-05-28	9.4 (20)
307	2	16	394	0	Baser	2017-06-29	8.4 (10)
23	3	1290	391	116	Palkin	2007-03-29	8.4 (307)
202	2	23	390	0	qwrqwr	2013-11-01	9.8 (12)
142	2	111	388	1	paparome	2007-03-24	9.0 (47)
80	2	283	380	11	qwrqwr	2011-10-21	9.0 (112)
166	1	57	375	2	anddros	2010-07-26	9.6 (30)
177	1	50	372	0	pegoopik	2011-07-17	8.3 (24)
88	3	243	370	2	crescent	2011-03-23	8.8 (97)
254	1	42	349	2	Baser	2011-09-02	8.6 (25)
215	2	19	333	0	pegoopik	2015-03-06	9.1 (10)
170	2	51	332	1	qwrqwr	2010-10-24	9.0 (25)
139	2	123	332	2	Snowbear	2006-09-09	8.3 (44)
36	3	805	325	18	risp	2011-05-06	7.9 (252)
209	1	31	319	1	Baser	2013-12-30	7.9 (14)
92	2	524	317	9	paparome	2006-07-26	8.4 (109)
47	3	758	298	14	qwrqwr	2010-11-20	8.0 (239)
60	3	1886	287	120	Serge I	2005-03-05	7.7 (280)
41	3	920	287	20	qwrqwr	2010-04-26	7.9 (298)
111	2	424	277	3	Fiolent	2005-01-19	8.3 (85)
54	2	1154	258	45	Ozzy	2008-09-06	8.2 (405)
29	2	830	252	38	GiBis	2011-09-17	7.4 (270)
34	2	939	242	24	qwrqwr	2010-09-24	7.9 (295)
118	2	401	242	1	Fiolent	2004-01-05	8.2 (77)
67	2	485	232	15	Ozzy	2010-04-27	8.3 (170)
204	1	32	232	1	anddros	2013-11-19	8.6 (16)
133	2	84	228	0	pickman	2011-07-01	8.2 (45)
91	2	190	222	0	smog	2012-05-26	9.1 (76)
105	2	109	219	1	Baser	2013-09-20	8.6 (42)
122	1	109	214	2	Dmitrij Grinkevich	2012-09-14	5.9 (47)
129	2	265	210	7	DimaN	2004-03-01	7.4 (55)
95	1	47	210	2	qwrqwr	2017-12-01	9.2 (24)
131	2	83	198	1	GriGrim	2012-05-25	8.5 (40)
112	2	404	196	3	VIG	2005-06-26	7.5 (71)
43	2	311	190	3	qwrqwr	2015-04-24	8.5 (108)
49	2	992	186	21	anddros	2009-06-05	7.8 (312)
75	2	330	185	5	qwrqwr	2011-07-22	7.4 (117)
260	2	50	183	0	qwrqwr	2012-02-03	7.6 (33)
20	2	1214	182	31	VIG	2003-09-01	8.0 (277)
261	1	33	169	1	Fomichev	2013-12-07	6.8 (18)
86	2	300	168	0	Ozzy	2010-03-05	8.6 (100)
61	2	790	167	4	risp	2009-12-26	8.4 (266)
304	2	23	165	0	aks_nsk	2016-02-05	9.4 (14)
62	2	535	163	8	Dmitrij Grinkevich	2012-02-11	7.9 (176)
16	2	588	163	57	qwrqwr	2014-07-18	7.4 (181)
124	2	353	160	3	DimaN	2004-02-26	8.2 (78)
59	2	731	148	5	VIG	2003-12-22	8.5 (153)
74	2	602	143	8	vlksm	2008-06-21	8.2 (180)
203	1	38	139	1	=Maxim=	2013-10-05	9.4 (22)
109	2	464	137	2	VIG	2003-12-23	8.0 (84)
52	1	295	136	3	Serge I	2015-01-10	8.7 (96)
38	2	808	125	20	ZrenBy	2003-09-01	7.8 (152)
83	2	485	124	4	lepton	2006-09-29	8.4 (125)
94	2	221	120	0	pickman	2011-04-27	8.2 (80)
35	3	326	119	8	Baser	2015-09-18	9.0 (107)
201	2	36	119	0	Baser	2013-09-21	8.7 (22)
81	2	538	118	12	$erges	2008-05-10	8.2 (147)
78	2	359	115	3	_ORA_	2010-04-27	7.5 (112)
39	2	1167	112	17	Serge I	2003-08-28	7.5 (222)
33	2	1017	109	24	DimaN	2004-03-01	7.6 (296)
57	2	1673	109	14	Serge I	2005-05-07	7.7 (262)
197	1	41	107	0	pegoopik	2013-06-10	8.7 (18)
128	1	219	106	4	inkerman	2007-09-14	8.3 (69)
46	2	1002	104	126	Serge I	2009-08-12	6.6 (275)
79	1	911	104	14	Serge I	2003-06-05	7.6 (136)
70	1	595	102	3	Serge I	2009-04-17	7.9 (194)
90	1	201	102	0	Dmitrij Grinkevich	2012-03-03	7.7 (70)
44	2	536	101	6	Serge I	2011-11-25	8.0 (175)
305	1	23	101	0	Baser	2017-01-06	8.8 (12)
73	1	390	98	2	Ruslan1707	2010-11-02	7.4 (124)
104	1	112	98	1	pegoopik	2013-07-19	8.4 (49)
113	1	105	91	0	smog	2013-03-29	8.4 (45)
103	1	113	89	1	Baser	2013-10-05	7.2 (45)
50	1	617	87	8	mslava	2003-12-22	8.4 (130)
10	1	303	87	27	Serge I	2017-01-20	8.1 (110)
40	2	1946	83	73	Serge I	2003-04-08	7.8 (297)
114	1	422	83	4	Serge I	2003-12-24	8.4 (82)
17	2	1333	82	15	VIG	2003-04-29	8.2 (256)
25	2	970	77	30	DimaN	2004-06-22	7.0 (264)
51	1	348	77	5	Fiolent	2004-06-23	8.0 (91)
24	2	1365	76	7	Aaz	2004-02-26	6.8 (394)
256	1	38	74	1	anddros	2013-11-08	8.9 (19)
9	2	1017	71	10	vasia armor	2010-05-21	7.8 (294)
26	1	1230	69	20	VIG	2003-12-22	7.7 (303)
55	2	1203	67	72	Serge I	2008-06-21	7.5 (310)
32	1	1120	66	8	Roman Golubin	2005-12-13	7.5 (258)
21	1	927	61	7	paparome	2006-03-14	7.9 (216)
28	1	956	59	12	ZrenBy	2003-09-01	7.5 (176)
97	1	333	59	4	dimzv	2004-03-01	7.8 (69)
42	1	1420	58	14	Serge I	2003-06-05	7.6 (268)
117	1	403	56	0	Fiolent	2003-12-26	7.6 (74)
48	1	966	52	6	Serge I	2009-06-22	7.3 (256)
192	2	46	52	0	Baser	2012-03-03	9.1 (24)
18	1	1348	51	6	ZrenBy	2003-09-01	7.5 (299)
30	1	1514	50	3	Serge I	2003-08-28	7.8 (325)
31	1	796	48	7	Fiolent	2004-06-22	7.7 (194)
56	1	865	48	3	Fiolent	2004-06-22	7.8 (227)
19	1	1716	47	22	Serge I	2004-06-23	7.4 (350)
27	1	1024	47	8	Fiolent	2004-02-26	7.2 (236)
14	1	2138	46	35	Serge I	2003-04-08	7.4 (362)
22	1	1350	45	11	ZrenBy	2003-09-01	7.2 (313)
108	1	468	45	0	mslava	2003-12-23	7.4 (82)
302	0	35	45	0	pegoopik	2012-07-27	7.7 (10)
12	1	2099	43	59	Serge I	2006-11-17	7.9 (377)
63	1	1158	41	6	VIG	2003-06-05	7.5 (194)
53	1	1278	41	25	DimaN	2004-03-01	7.5 (326)
13	1	1409	36	19	ZrenBy	2003-09-01	7.3 (334)
11	1	1566	33	11	ZrenBy	2003-09-01	7.4 (355)
15	1	897	31	5	Dmitrij Grinkevich	2012-04-21	7.3 (260)
301	0	41	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