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

December 18, 14:58 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

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	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	4	6186	0	mcrain	2018-08-24	10.0 (2)
206	4	13	6127	0	Baser	2013-11-23	9.0 (11)
225	2	9	6053	0	pegoopik	2017-07-15	9.8 (6)
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	2	Ozzy	2009-11-06	9.5 (16)
160	3	24	4731	1	Ozzy	2009-08-07	9.7 (15)
211	2	12	4638	2	Baser	2014-06-30	9.8 (8)
220	3	6	4388	1	pegoopik	2016-12-17	10.0 (3)
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	20	3717	0	Ozzy	2011-03-11	9.7 (14)
171	3	19	3682	1	Ozzy	2010-12-05	9.3 (15)
116	5	222	3492	21	$erges	2008-12-13	9.3 (104)
218	4	11	3491	1	al29	2016-04-04	9.6 (7)
119	5	83	3203	5	Velmont	2014-03-07	9.7 (44)
188	3	16	3191	1	qwrqwr	2012-02-04	9.8 (12)
151	3	32	3152	4	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)
167	3	21	3032	0	qwrqwr	2011-01-18	9.9 (14)
156	2	50	3004	3	anddros	2009-04-17	9.1 (28)
232	3	4	2940	0	al29	2018-08-20	10.0 (3)
144	4	41	2928	4	pvv	2008-01-01	7.3 (25)
100	4	224	2919	9	qwrqwr	2010-04-27	9.4 (111)
187	3	23	2802	1	=Maxim=	2011-12-31	8.7 (19)
102	4	158	2786	7	GriGrim	2011-07-16	9.4 (72)
153	3	35	2779	4	Ozzy	2009-02-14	9.5 (20)
120	4	82	2597	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)
179	3	17	2329	0	pegoopik	2011-09-17	9.2 (12)
178	3	22	2268	1	Baser	2011-08-13	9.1 (15)
141	4	75	2225	8	vlksm	2006-10-29	9.0 (33)
227	3	9	2137	0	mcrain	2017-12-08	7.0 (5)
210	2	14	2132	0	_dimon_	2014-02-07	10.0 (11)
101	4	191	2102	15	pegoopik	2010-11-20	9.4 (101)
145	3	68	2007	1	pvv	2008-01-07	8.6 (33)
184	2	25	1953	0	Baser	2011-11-26	9.1 (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	13	1906	1	qwrqwr	2018-01-12	10.0 (8)
98	4	557	1900	44	ZrenBy	2003-09-01	8.2 (118)
72	4	955	1860	149	paparome	2005-12-03	9.2 (244)
87	4	602	1770	84	Roman Golubin	2006-07-14	9.3 (163)
146	3	59	1743	3	paparome	2008-01-22	9.7 (33)
205	2	14	1707	0	qwrqwr	2013-11-22	8.8 (9)
89	3	384	1658	30	_Bkmz_	2008-06-21	7.9 (139)
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	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	4	GriGrim	2011-11-12	9.0 (14)
132	3	104	1489	4	risp	2010-01-25	7.7 (53)
121	3	384	1486	4	ZrenBy	2004-02-26	7.8 (89)
219	2	14	1482	0	pegoopik	2016-04-08	9.9 (8)
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)
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	224	1390	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)
96	3	387	1354	81	anddros	2008-11-22	8.8 (150)
176	3	28	1341	0	qwrqwr	2011-05-20	9.5 (20)
76	3	398	1338	13	silver	2010-01-23	8.8 (157)
77	2	248	1327	32	selber	2015-07-10	8.7 (104)
106	3	258	1322	6	vlksm	2008-11-27	8.7 (109)
207	3	12	1255	0	pegoopik	2016-01-15	10.0 (8)
85	3	325	1247	17	Ozzy	2009-10-10	8.5 (126)
226	3	8	1235	1	pegoopik	2017-10-14	9.2 (5)
69	2	80	1214	8	Gosha	2017-12-15	9.4 (32)
82	3	340	1187	10	_Virt_	2010-04-27	8.1 (124)
65	3	613	1165	41	Ozzy	2010-01-29	7.7 (221)
45	2	248	1164	24	dumkan	2016-04-03	7.9 (76)
93	3	139	1134	5	qwrqwr	2014-03-14	9.3 (58)
140	2	78	1126	2	_Bkmz_	2010-01-30	8.9 (40)
68	3	213	1092	18	pegoopik	2014-08-01	8.1 (84)
134	3	170	1049	4	pvv	2008-01-22	8.6 (68)
84	3	371	1008	16	Ozzy	2009-12-26	8.3 (135)
37	3	562	969	23	qwrqwr	2013-02-22	8.0 (207)
168	2	40	945	1	qwrqwr	2010-08-27	9.5 (23)
173	1	50	938	2	Ozzy	2011-01-13	9.3 (28)
186	1	34	902	0	Ozzy	2011-12-30	9.8 (22)
71	3	475	756	19	anddros	2009-12-26	8.3 (164)
125	3	350	735	3	dimzv	2004-02-29	8.7 (82)
213	2	24	721	0	qwrqwr	2014-10-17	9.1 (14)
58	3	449	720	10	qwrqwr	2013-03-01	8.1 (166)
110	3	408	707	11	Snowbear	2006-03-14	8.8 (102)
195	3	23	669	0	Dmitrij Grinkevich	2013-04-20	9.1 (14)
99	3	169	659	8	Dmitrij Grinkevich	2012-05-05	8.0 (66)
126	2	174	627	9	$erges	2008-09-07	8.5 (84)
251	4	66	594	3	paparome	2006-10-01	7.9 (27)
185	1	41	583	3	=Maxim=	2011-11-25	8.2 (24)
162	2	57	554	1	Ozzy	2009-12-26	9.3 (34)
64	3	488	549	45	qwrqwr	2010-05-13	7.8 (156)
130	2	110	541	0	anddros	2010-05-22	8.8 (55)
202	2	26	504	0	qwrqwr	2013-11-01	9.1 (14)
174	1	54	489	0	qwrqwr	2011-02-25	9.3 (32)
66	3	580	449	50	anddros	2009-12-26	8.4 (222)
127	2	50	443	2	GriGrim	2014-12-21	7.5 (22)
107	2	381	428	9	Fiolent	2004-02-26	8.3 (88)
307	2	17	421	0	Baser	2017-06-29	8.4 (10)
115	2	55	405	1	selber	2016-05-28	9.4 (22)
23	3	1323	397	116	Palkin	2007-03-29	8.4 (315)
142	2	112	388	1	paparome	2007-03-24	9.0 (47)
80	2	291	379	10	qwrqwr	2011-10-21	8.9 (115)
177	1	51	372	0	pegoopik	2011-07-17	8.4 (25)
166	1	58	358	2	anddros	2010-07-26	9.6 (30)
254	1	42	349	2	Baser	2011-09-02	8.6 (25)
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	249	329	3	crescent	2011-03-23	8.8 (99)
36	3	830	320	19	risp	2011-05-06	7.9 (259)
209	1	31	319	1	Baser	2013-12-30	7.9 (14)
92	2	530	310	9	paparome	2006-07-26	8.4 (110)
47	3	778	301	15	qwrqwr	2010-11-20	8.0 (243)
41	3	939	283	19	qwrqwr	2010-04-26	7.9 (301)
60	3	1904	280	119	Serge I	2005-03-05	7.7 (285)
111	2	430	277	3	Fiolent	2005-01-19	8.2 (86)
54	2	1171	255	44	Ozzy	2008-09-06	8.2 (411)
29	2	859	249	39	GiBis	2011-09-17	7.4 (280)
118	2	405	242	1	Fiolent	2004-01-05	8.2 (78)
34	2	966	239	25	qwrqwr	2010-09-24	7.9 (302)
122	1	113	237	2	Dmitrij Grinkevich	2012-09-14	5.9 (47)
133	2	85	233	0	pickman	2011-07-01	8.2 (45)
67	2	496	232	17	Ozzy	2010-04-27	8.3 (172)
204	1	32	232	1	anddros	2013-11-19	8.6 (16)
105	2	116	219	0	Baser	2013-09-20	8.5 (44)
91	2	196	211	0	smog	2012-05-26	9.1 (78)
129	2	265	210	7	DimaN	2004-03-01	7.4 (55)
131	2	84	198	1	GriGrim	2012-05-25	8.5 (40)
112	2	410	196	3	VIG	2005-06-26	7.5 (72)
49	2	1010	185	22	anddros	2009-06-05	7.8 (316)
260	2	50	183	0	qwrqwr	2012-02-03	7.6 (33)
20	2	1250	182	31	VIG	2003-09-01	8.0 (284)
75	2	339	180	4	qwrqwr	2011-07-22	7.5 (120)
43	2	336	175	2	qwrqwr	2015-04-24	8.4 (115)
86	2	307	169	0	Ozzy	2010-03-05	8.6 (102)
261	1	33	169	1	Fomichev	2013-12-07	6.8 (18)
16	2	628	166	59	qwrqwr	2014-07-18	7.4 (191)
61	2	807	166	5	risp	2009-12-26	8.4 (270)
62	2	553	165	8	Dmitrij Grinkevich	2012-02-11	7.9 (179)
95	1	59	162	2	qwrqwr	2017-12-01	9.3 (27)
124	2	356	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	751	148	4	VIG	2003-12-22	8.4 (158)
74	2	608	140	8	vlksm	2008-06-21	8.3 (181)
109	2	469	137	2	VIG	2003-12-23	8.0 (86)
52	1	315	129	3	Serge I	2015-01-10	8.6 (101)
38	2	830	129	22	ZrenBy	2003-09-01	7.7 (157)
83	2	491	120	4	lepton	2006-09-29	8.4 (129)
94	2	227	119	0	pickman	2011-04-27	8.2 (81)
201	2	36	119	0	Baser	2013-09-21	8.7 (22)
81	2	546	116	13	$erges	2008-05-10	8.2 (150)
78	2	366	116	3	_ORA_	2010-04-27	7.4 (113)
39	2	1188	115	18	Serge I	2003-08-28	7.5 (226)
35	3	357	113	10	Baser	2015-09-18	8.9 (114)
33	2	1045	109	24	DimaN	2004-03-01	7.6 (303)
104	1	118	108	0	pegoopik	2013-07-19	8.3 (50)
57	2	1690	107	14	Serge I	2005-05-07	7.7 (265)
197	1	42	107	0	pegoopik	2013-06-10	8.8 (19)
128	1	219	106	4	inkerman	2007-09-14	8.3 (69)
44	2	560	105	4	Serge I	2011-11-25	7.9 (184)
46	2	1023	103	126	Serge I	2009-08-12	6.6 (278)
79	1	917	103	14	Serge I	2003-06-05	7.6 (137)
90	1	207	102	0	Dmitrij Grinkevich	2012-03-03	7.7 (71)
70	1	603	101	3	Serge I	2009-04-17	7.9 (195)
305	1	23	101	0	Baser	2017-01-06	8.8 (12)
73	1	398	97	2	Ruslan1707	2010-11-02	7.4 (125)
113	1	112	91	0	smog	2013-03-29	8.4 (46)
50	1	640	87	11	mslava	2003-12-22	8.3 (136)
17	2	1382	86	16	VIG	2003-04-29	8.1 (266)
103	1	118	86	1	Baser	2013-10-05	7.2 (46)
114	1	428	83	4	Serge I	2003-12-24	8.3 (83)
10	1	373	83	36	Serge I	2017-01-20	8.2 (131)
40	2	1964	83	75	Serge I	2003-04-08	7.7 (302)
51	1	372	80	8	Fiolent	2004-06-23	7.9 (97)
25	2	1001	78	32	DimaN	2004-06-22	6.9 (272)
306	1	10	78	0	Serge I	2018-09-07	9.4 (7)
24	2	1397	76	6	Aaz	2004-02-26	6.8 (402)
256	1	38	74	1	anddros	2013-11-08	8.9 (19)
9	2	1076	72	16	vasia armor	2010-05-21	7.8 (322)
26	1	1259	69	22	VIG	2003-12-22	7.7 (310)
55	2	1220	67	72	Serge I	2008-06-21	7.5 (314)
32	1	1148	65	8	Roman Golubin	2005-12-13	7.5 (262)
21	1	959	62	10	paparome	2006-03-14	7.9 (221)
28	1	986	61	11	ZrenBy	2003-09-01	7.5 (182)
97	1	341	60	3	dimzv	2004-03-01	7.7 (71)
42	1	1439	58	14	Serge I	2003-06-05	7.6 (272)
117	1	407	55	0	Fiolent	2003-12-26	7.6 (75)
18	1	1383	52	6	ZrenBy	2003-09-01	7.5 (305)
192	2	46	52	0	Baser	2012-03-03	9.1 (24)
48	1	986	51	6	Serge I	2009-06-22	7.4 (259)
30	1	1542	50	3	Serge I	2003-08-28	7.8 (334)
27	1	1052	49	9	Fiolent	2004-02-26	7.2 (243)
31	1	825	48	7	Fiolent	2004-06-22	7.7 (202)
56	1	882	48	3	Fiolent	2004-06-22	7.8 (231)
19	1	1752	47	22	Serge I	2004-06-23	7.4 (357)
14	1	2180	46	37	Serge I	2003-04-08	7.5 (371)
108	1	473	46	0	mslava	2003-12-23	7.3 (84)
22	1	1382	45	11	ZrenBy	2003-09-01	7.2 (319)
302	0	35	45	0	pegoopik	2012-07-27	7.7 (10)
12	1	2145	42	59	Serge I	2006-11-17	7.9 (388)
63	1	1176	42	5	VIG	2003-06-05	7.4 (198)
53	1	1293	41	25	DimaN	2004-03-01	7.5 (330)
13	1	1454	37	20	ZrenBy	2003-09-01	7.3 (342)
11	1	1613	33	14	ZrenBy	2003-09-01	7.4 (366)
15	1	937	32	7	Dmitrij Grinkevich	2012-04-21	7.4 (269)
301	0	42	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