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

October 15, 23:01 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

  • Site rules
  • 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);
Length - wording length in symbols;
Rank - average score on a result of voting.

No	Bonus	Solved	Time(min)	noOK	Length	Author	Date	Rank
217	4	9	31871	4	549	pegoopik	2015-08-28	9.2 (5)
147	4	26	14593	2	1213	$erges	2010-08-06	9.7 (19)
157	3	24	12925	2	960	anddros	2009-06-05	9.6 (15)
163	3	19	11408	0	1640	Ozzy	2010-01-08	9.6 (14)
143	5	44	11333	14	946	inkerman	2007-10-07	8.8 (29)
214	4	10	9964	0	433	pegoopik	2015-05-30	10.0 (6)
259	4	22	9370	1	276	anddros	2009-08-24	9.5 (13)
155	3	25	8819	3	761	vlksm	2009-04-17	10.0 (17)
216	3	11	8681	1	279	pegoopik	2015-05-15	9.9 (8)
194	4	14	7588	2	1461	pegoopik	2012-07-13	10.0 (10)
253	3	30	7278	7	1097	$erges	2008-05-17	8.9 (20)
138	5	144	6385	32	949	Cyrilus	2005-12-09	9.2 (64)
161	3	21	6370	2	889	Ozzy	2009-11-06	9.2 (17)
224	3	10	6363	0	1979	selber	2017-04-14	9.4 (7)
231	3	5	6186	0	787	mcrain	2018-08-24	10.0 (3)
206	4	14	6127	0	1484	Baser	2013-11-23	9.1 (12)
225	2	9	6053	0	737	pegoopik	2017-07-15	9.8 (6)
211	2	13	5791	1	588	Baser	2014-06-30	9.8 (9)
230	2	6	5717	0	728	pegoopik	2018-07-27	9.8 (4)
255	4	13	5666	4	793	vlksm	2012-02-14	9.9 (8)
229	3	6	5468	1	1532	al29	2018-03-23	9.6 (5)
181	4	14	5296	1	1869	Ozzy	2011-10-08	9.7 (9)
154	4	25	4892	3	848	anddros	2009-03-18	9.9 (17)
160	3	26	4731	0	961	Ozzy	2009-08-07	9.6 (17)
159	3	17	4480	0	565	anddros	2012-07-22	8.2 (14)
220	3	6	4388	1	1175	pegoopik	2016-12-17	10.0 (3)
232	3	5	4384	0	513	al29	2018-08-20	10.0 (4)
191	3	14	4212	0	948	qwrqwr	2012-06-08	9.5 (11)
252	2	33	4021	3	308	Ozzy	2009-06-14	8.3 (22)
149	3	33	3909	2	506	$erges	2008-09-08	9.2 (21)
257	4	16	3753	1	2758	pegoopik	2012-02-20	9.4 (12)
172	3	21	3717	0	1719	Ozzy	2011-03-11	9.7 (15)
171	3	19	3682	1	1670	Ozzy	2010-12-05	9.3 (15)
116	5	229	3494	20	469	$erges	2008-12-13	9.3 (107)
218	4	12	3491	2	1500	al29	2016-04-04	9.6 (7)
119	5	91	3203	5	703	Velmont	2014-03-07	9.7 (48)
188	3	17	3191	1	733	qwrqwr	2012-02-04	9.8 (12)
151	3	32	3152	5	1096	anddros	2008-12-30	8.9 (19)
189	4	14	3087	0	1563	Baser	2012-02-05	8.5 (11)
208	3	14	3063	0	821	pegoopik	2013-12-20	8.8 (12)
156	2	51	3004	3	391	anddros	2009-04-17	9.1 (29)
144	4	44	2928	4	950	pvv	2008-01-01	7.3 (27)
100	4	228	2916	9	650	qwrqwr	2010-04-27	9.4 (112)
167	3	22	2887	0	674	qwrqwr	2011-01-18	9.9 (15)
187	3	24	2802	0	978	=Maxim=	2011-12-31	8.8 (20)
102	4	164	2786	6	933	GriGrim	2011-07-16	9.4 (74)
153	3	35	2779	4	1539	Ozzy	2009-02-14	9.5 (20)
120	4	90	2597	1	239	pegoopik	2014-02-14	8.9 (43)
221	2	13	2539	0	1023	Baser	2016-11-05	8.6 (8)
190	4	16	2521	1	717	vlksm	2012-03-17	8.8 (13)
141	4	77	2335	9	977	vlksm	2006-10-29	9.0 (35)
179	3	17	2329	0	844	pegoopik	2011-09-17	9.2 (12)
178	3	22	2268	1	1680	Baser	2011-08-13	9.1 (15)
227	3	9	2137	1	2142	mcrain	2017-12-08	7.0 (5)
210	2	14	2132	0	483	_dimon_	2014-02-07	10.0 (11)
101	4	196	2125	14	1096	pegoopik	2010-11-20	9.4 (103)
145	3	68	2007	1	859	pvv	2008-01-07	8.6 (33)
184	2	25	1953	1	432	Baser	2011-11-26	8.8 (19)
72	4	976	1941	151	608	paparome	2005-12-03	9.2 (253)
164	2	36	1915	1	1622	anddros	2010-04-26	9.7 (22)
148	2	64	1910	8	894	vlksm	2008-09-06	9.3 (35)
228	1	16	1906	1	1419	qwrqwr	2018-01-12	10.0 (10)
98	4	561	1900	44	538	ZrenBy	2003-09-01	8.2 (119)
205	2	15	1877	0	529	qwrqwr	2013-11-22	8.9 (10)
193	2	21	1798	0	522	Baser	2012-07-06	8.3 (15)
87	4	610	1787	87	459	Roman Golubin	2006-07-14	9.3 (166)
146	3	59	1743	3	949	paparome	2008-01-22	9.7 (33)
89	3	391	1686	29	870	_Bkmz_	2008-06-21	7.8 (142)
165	2	29	1631	3	1600	vlksm	2010-03-18	9.9 (18)
137	4	188	1619	24	616	Cyrilus	2005-03-06	9.2 (66)
183	2	29	1611	2	518	GriGrim	2011-11-12	9.1 (15)
223	2	11	1596	1	641	Baser	2016-11-12	9.7 (7)
222	2	11	1583	1	1475	pegoopik	2016-12-23	9.8 (8)
182	3	22	1566	0	1377	Baser	2011-10-29	8.1 (17)
175	3	29	1548	0	2151	pegoopik	2011-04-28	8.5 (22)
196	3	23	1529	0	661	qwrqwr	2013-05-17	9.4 (14)
121	3	391	1527	4	804	ZrenBy	2004-02-26	7.8 (90)
169	3	29	1519	0	1559	Valdaj	2010-09-02	8.4 (21)
136	3	110	1492	5	618	Ozzy	2011-05-12	7.3 (47)
176	3	29	1484	0	385	qwrqwr	2011-05-20	9.5 (21)
219	2	14	1482	0	486	pegoopik	2016-04-08	9.9 (8)
132	3	106	1472	4	2500	risp	2010-01-25	7.7 (53)
200	3	17	1463	0	1129	qwrqwr	2013-10-05	9.3 (12)
158	3	36	1452	0	1174	Ozzy	2010-04-09	9.0 (22)
123	3	230	1445	39	1254	Ozzy	2009-08-22	9.0 (106)
198	2	21	1444	0	332	Angellore	2013-09-13	9.4 (15)
150	4	34	1442	4	909	@Nikotin	2008-11-09	8.5 (20)
152	3	44	1420	4	1301	vlksm	2009-01-05	9.7 (26)
212	3	15	1403	0	585	Baser	2014-10-14	8.8 (10)
135	3	61	1376	1	854	qwrqwr	2013-04-19	8.9 (33)
180	3	29	1375	0	274	qwrqwr	2011-09-16	9.6 (22)
199	3	18	1371	0	1448	Baser	2013-08-17	8.3 (13)
106	3	265	1362	5	647	vlksm	2008-11-27	8.7 (111)
76	3	416	1348	14	949	silver	2010-01-23	8.8 (165)
213	2	25	1346	0	369	qwrqwr	2014-10-17	9.6 (15)
96	3	391	1329	81	572	anddros	2008-11-22	8.8 (150)
77	2	270	1327	31	1052	selber	2015-07-10	8.7 (112)
85	3	336	1268	17	1397	Ozzy	2009-10-10	8.5 (129)
207	3	13	1255	0	486	pegoopik	2016-01-15	10.0 (8)
69	2	114	1246	9	210	Gosha	2017-12-15	9.3 (38)
226	3	9	1235	1	2054	pegoopik	2017-10-14	9.2 (5)
82	3	353	1235	13	1780	_Virt_	2010-04-27	8.2 (128)
186	1	36	1215	0	1447	Ozzy	2011-12-30	9.2 (24)
65	3	646	1178	44	671	Ozzy	2010-01-29	7.8 (232)
68	3	242	1174	19	608	pegoopik	2014-08-01	8.1 (94)
173	1	51	1172	3	945	Ozzy	2011-01-13	9.3 (28)
168	2	41	1159	2	455	qwrqwr	2010-08-27	9.5 (24)
84	3	383	1140	17	815	Ozzy	2009-12-26	8.3 (137)
93	3	144	1134	7	492	qwrqwr	2014-03-14	9.3 (58)
134	3	171	1049	4	821	pvv	2008-01-22	8.6 (68)
37	3	623	960	24	673	qwrqwr	2013-02-22	8.1 (226)
140	2	80	925	2	578	_Bkmz_	2010-01-30	8.9 (40)
233	1	9	868	0	2321	pegoopik	2019-03-08	10.0 (5)
71	3	498	829	18	941	anddros	2009-12-26	8.4 (170)
45	2	313	808	21	509	dumkan	2016-04-03	7.9 (92)
125	3	356	765	3	526	dimzv	2004-02-29	8.7 (83)
110	3	415	697	11	942	Snowbear	2006-03-14	8.8 (105)
195	3	25	669	0	722	Dmitrij Grinkevich	2013-04-20	9.1 (15)
127	2	53	642	2	985	GriGrim	2014-12-21	7.6 (23)
126	2	177	633	11	944	$erges	2008-09-07	8.5 (86)
58	3	501	632	10	440	qwrqwr	2013-03-01	8.2 (185)
251	4	68	594	3	850	paparome	2006-10-01	8.0 (29)
162	2	59	592	0	1067	Ozzy	2009-12-26	9.3 (34)
185	1	42	583	3	782	=Maxim=	2011-11-25	7.9 (25)
130	2	113	559	0	700	anddros	2010-05-22	8.8 (56)
64	3	525	543	44	508	qwrqwr	2010-05-13	7.9 (168)
174	1	55	535	1	1084	qwrqwr	2011-02-25	9.3 (32)
99	3	174	510	8	956	Dmitrij Grinkevich	2012-05-05	8.0 (67)
202	2	28	504	0	557	qwrqwr	2013-11-01	9.1 (16)
66	3	610	449	52	392	anddros	2009-12-26	8.4 (232)
307	2	17	421	0	1095	Baser	2017-06-29	8.4 (10)
254	1	43	420	2	1383	Baser	2011-09-02	8.7 (26)
107	2	388	417	9	688	Fiolent	2004-02-26	8.3 (90)
115	2	62	405	1	736	selber	2016-05-28	9.1 (24)
23	3	1395	391	118	249	Palkin	2007-03-29	8.3 (339)
142	2	113	388	1	944	paparome	2007-03-24	9.0 (47)
166	1	59	375	2	449	anddros	2010-07-26	9.6 (30)
177	1	52	372	0	935	pegoopik	2011-07-17	8.5 (26)
80	2	308	364	11	453	qwrqwr	2011-10-21	8.9 (121)
215	2	22	333	0	331	pegoopik	2015-03-06	9.3 (13)
170	2	53	332	1	320	qwrqwr	2010-10-24	9.0 (27)
88	3	257	329	4	521	crescent	2011-03-23	8.8 (101)
209	1	32	319	1	735	Baser	2013-12-30	8.0 (15)
36	3	892	318	20	788	risp	2011-05-06	7.9 (279)
92	2	536	317	9	405	paparome	2006-07-26	8.4 (112)
139	2	124	310	2	907	Snowbear	2006-09-09	8.3 (44)
47	3	831	291	15	608	qwrqwr	2010-11-20	8.0 (261)
111	2	437	280	3	545	Fiolent	2005-01-19	8.2 (89)
41	3	996	279	18	271	qwrqwr	2010-04-26	8.0 (323)
60	3	1953	268	120	353	Serge I	2005-03-05	7.7 (302)
29	2	926	256	39	695	GiBis	2011-09-17	7.5 (303)
54	2	1224	255	44	706	Ozzy	2008-09-06	8.2 (430)
234	2	6	243	0	684	selber	2019-06-21	5.7 (3)
204	1	33	241	1	366	anddros	2013-11-19	8.7 (17)
118	2	412	236	1	206	Fiolent	2004-01-05	8.2 (80)
40	1	134	236	16	398	Serge I	2018-09-07	7.4 (42)
133	2	87	233	0	1614	pickman	2011-07-01	8.2 (45)
34	2	1028	231	25	750	qwrqwr	2010-09-24	7.9 (324)
105	2	122	219	0	610	Baser	2013-09-20	8.5 (45)
122	1	120	217	2	725	Dmitrij Grinkevich	2012-09-14	5.9 (47)
91	2	204	215	0	642	smog	2012-05-26	9.2 (80)
67	2	526	214	17	729	Ozzy	2010-04-27	8.3 (182)
129	2	268	206	7	658	DimaN	2004-03-01	7.5 (56)
112	2	417	195	3	324	VIG	2005-06-26	7.5 (74)
131	2	86	192	1	498	GriGrim	2012-05-25	8.5 (40)
43	2	395	189	3	648	qwrqwr	2015-04-24	8.5 (133)
75	2	358	186	5	644	qwrqwr	2011-07-22	7.4 (127)
49	2	1063	184	22	862	anddros	2009-06-05	7.8 (332)
260	2	51	183	0	999	qwrqwr	2012-02-03	7.7 (34)
20	2	1322	181	34	249	VIG	2003-09-01	7.9 (309)
62	2	601	171	8	446	Dmitrij Grinkevich	2012-02-11	8.0 (193)
86	2	318	170	0	433	Ozzy	2010-03-05	8.6 (104)
261	1	35	169	1	1495	Fomichev	2013-12-07	7.0 (19)
61	2	855	168	5	781	risp	2009-12-26	8.4 (286)
16	2	711	166	61	356	qwrqwr	2014-07-18	7.5 (218)
95	1	69	162	2	350	qwrqwr	2017-12-01	9.3 (28)
203	1	39	160	1	932	=Maxim=	2013-10-05	9.4 (23)
124	2	362	160	3	455	DimaN	2004-02-26	8.3 (79)
304	2	24	151	0	1132	aks_nsk	2016-02-05	9.3 (15)
59	2	801	150	6	220	VIG	2003-12-22	8.4 (173)
38	2	893	140	23	297	ZrenBy	2003-09-01	7.7 (175)
74	2	628	140	8	855	vlksm	2008-06-21	8.3 (185)
12	1	121	138	23	348	Serge I	2019-04-12	7.7 (39)
109	2	477	133	1	671	VIG	2003-12-23	7.9 (88)
201	2	37	127	0	749	Baser	2013-09-21	8.7 (23)
78	2	384	122	3	451	_ORA_	2010-04-27	7.5 (117)
83	2	504	120	4	798	lepton	2006-09-29	8.5 (133)
39	2	1250	120	17	263	Serge I	2003-08-28	7.4 (247)
94	2	232	119	0	773	pickman	2011-04-27	8.2 (81)
81	2	563	118	13	707	$erges	2008-05-10	8.2 (154)
52	1	375	118	3	274	Serge I	2015-01-10	8.7 (115)
33	2	1109	114	24	358	DimaN	2004-03-01	7.6 (319)
35	3	425	111	9	688	Baser	2015-09-18	8.7 (137)
104	1	123	108	0	571	pegoopik	2013-07-19	8.3 (51)
197	1	42	107	0	518	pegoopik	2013-06-10	8.8 (19)
44	2	615	106	4	348	Serge I	2011-11-25	7.9 (200)
79	1	935	104	14	403	Serge I	2003-06-05	7.7 (143)
128	1	222	104	4	829	inkerman	2007-09-14	8.3 (70)
46	2	1077	103	126	376	Serge I	2009-08-12	6.7 (294)
57	2	1741	103	14	281	Serge I	2005-05-07	7.8 (280)
90	1	215	102	0	499	Dmitrij Grinkevich	2012-03-03	7.8 (73)
305	1	24	101	0	160	Baser	2017-01-06	8.8 (13)
70	1	626	100	3	334	Serge I	2009-04-17	7.9 (200)
73	1	417	96	2	367	Ruslan1707	2010-11-02	7.4 (133)
51	1	435	95	10	410	Fiolent	2004-06-23	8.0 (116)
50	1	702	92	10	414	mslava	2003-12-22	8.3 (151)
113	1	119	91	0	497	smog	2013-03-29	8.4 (48)
17	2	1460	87	17	118	VIG	2003-04-29	8.1 (288)
103	1	123	86	1	850	Baser	2013-10-05	7.2 (47)
8	2	2081	83	101	101	Serge I	2003-04-08	7.9 (355)
10	1	485	83	38	179	Serge I	2017-01-20	8.1 (153)
114	1	435	83	4	298	Serge I	2003-12-24	8.4 (86)
256	1	39	82	1	436	anddros	2013-11-08	8.9 (20)
25	2	1075	81	30	208	DimaN	2004-06-22	7.0 (292)
24	2	1469	77	6	631	Aaz	2004-02-26	6.9 (423)
9	2	1168	72	20	510	vasia armor	2010-05-21	7.9 (354)
26	1	1329	72	24	269	VIG	2003-12-22	7.7 (331)
55	2	1273	66	72	600	Serge I	2008-06-21	7.5 (329)
28	1	1054	64	13	266	ZrenBy	2003-09-01	7.5 (200)
32	1	1213	64	7	529	Roman Golubin	2005-12-13	7.5 (282)
21	1	1033	64	8	680	paparome	2006-03-14	7.9 (243)
97	1	346	61	3	231	dimzv	2004-03-01	7.7 (71)
42	1	1494	57	14	254	Serge I	2003-06-05	7.6 (287)
117	1	414	55	0	193	Fiolent	2003-12-26	7.6 (76)
18	1	1458	53	7	149	ZrenBy	2003-09-01	7.6 (326)
48	1	1039	52	6	317	Serge I	2009-06-22	7.4 (276)
192	2	47	52	0	709	Baser	2012-03-03	9.2 (25)
30	1	1606	51	3	154	Serge I	2003-08-28	7.9 (356)
27	1	1123	51	8	368	Fiolent	2004-02-26	7.2 (263)
31	1	890	48	7	342	Fiolent	2004-06-22	7.8 (223)
19	1	1826	48	22	279	Serge I	2004-06-23	7.5 (381)
56	1	933	48	4	581	Fiolent	2004-06-22	7.9 (247)
14	1	2260	47	37	133	Serge I	2003-04-08	7.5 (394)
108	1	480	46	0	412	mslava	2003-12-23	7.3 (86)
22	1	1455	45	11	261	ZrenBy	2003-09-01	7.2 (340)
302	0	37	45	0	510	pegoopik	2012-07-27	7.6 (11)
63	1	1223	43	5	190	VIG	2003-06-05	7.5 (213)
7	1	2241	42	65	303	Serge I	2006-11-17	8.0 (416)
53	1	1347	41	25	230	DimaN	2004-03-01	7.6 (347)
13	1	1536	38	20	231	ZrenBy	2003-09-01	7.4 (365)
15	1	1018	33	8	252	Dmitrij Grinkevich	2012-04-21	7.5 (289)
11	1	1697	33	14	125	ZrenBy	2003-09-01	7.4 (390)
306	1	10	28	0	541	Serge I	2019-07-05	10.0 (6)
258	3	25	13	0	1070	Baser	2014-09-19	7.6 (10)
301	0	43	8	0	55	pegoopik	2012-03-23	8.9 (20)
303	0	33	7	0	141	Serge I	2013-06-28	9.5 (14)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References