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

August 22, 08:32 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 
  • 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

Transact-SQL tests

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	6	17420	4	pegoopik	2015-08-28	9.3 (3)
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	3	10372	0	pegoopik	2017-07-15	10.0 (2)
259	4	21	9370	0	anddros	2009-08-24	9.5 (12)
253	3	27	8719	7	$erges	2008-05-17	8.9 (17)
155	3	22	8713	3	vlksm	2009-04-17	10.0 (14)
163	3	16	8342	0	Ozzy	2010-01-08	9.5 (11)
194	4	13	7588	1	pegoopik	2012-07-13	10.0 (9)
214	4	8	6392	2	pegoopik	2015-05-30	10.0 (6)
138	5	141	6386	32	Cyrilus	2005-12-09	9.1 (62)
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	17	4787	2	Ozzy	2009-11-06	9.5 (13)
160	3	22	4731	0	Ozzy	2009-08-07	9.6 (13)
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	21	4200	3	anddros	2009-03-18	9.9 (13)
206	4	11	4162	0	Baser	2013-11-23	8.8 (9)
149	3	27	3818	3	$erges	2008-09-08	9.0 (15)
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	29	3569	5	Ozzy	2009-06-14	8.3 (19)
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	9	qwrqwr	2010-04-27	9.4 (106)
188	3	14	3005	1	qwrqwr	2012-02-04	9.7 (10)
156	2	43	3004	2	anddros	2009-04-17	9.0 (23)
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	143	2835	6	GriGrim	2011-07-16	9.4 (68)
144	4	38	2809	3	pvv	2008-01-01	7.1 (22)
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	64	1999	1	pvv	2008-01-07	8.5 (29)
98	4	538	1950	46	ZrenBy	2003-09-01	8.1 (112)
164	2	29	1915	1	anddros	2010-04-26	9.8 (17)
148	2	59	1910	7	vlksm	2008-09-06	9.2 (31)
141	4	69	1897	8	vlksm	2006-10-29	9.0 (28)
72	4	930	1879	150	paparome	2005-12-03	9.2 (233)
87	4	582	1828	85	Roman Golubin	2006-07-14	9.3 (156)
153	3	28	1812	4	Ozzy	2009-02-14	9.4 (14)
193	2	17	1798	0	Baser	2012-07-06	8.2 (11)
89	3	366	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.5 (16)
150	4	31	1652	4	@Nikotin	2008-11-09	8.8 (17)
184	2	20	1643	0	Baser	2011-11-26	9.2 (15)
137	4	185	1632	24	Cyrilus	2005-03-06	9.2 (64)
179	3	14	1619	0	pegoopik	2011-09-17	9.0 (9)
146	3	54	1606	3	paparome	2008-01-22	9.7 (29)
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	107	1511	5	Ozzy	2011-05-12	7.5 (45)
175	3	24	1484	0	pegoopik	2011-04-28	8.4 (19)
135	3	57	1483	1	qwrqwr	2013-04-19	9.1 (30)
132	3	102	1472	4	risp	2010-01-25	7.8 (52)
121	3	375	1471	5	ZrenBy	2004-02-26	7.8 (88)
123	3	213	1457	38	Ozzy	2009-08-22	9.0 (102)
200	3	15	1452	0	qwrqwr	2013-10-05	9.2 (10)
198	2	16	1444	0	Angellore	2013-09-13	9.3 (12)
169	3	26	1443	0	Valdaj	2010-09-02	8.4 (18)
106	3	244	1432	6	vlksm	2008-11-27	8.8 (104)
215	2	15	1412	0	pegoopik	2015-03-06	8.9 (8)
77	2	218	1382	32	selber	2015-07-10	8.7 (92)
180	3	26	1375	0	qwrqwr	2011-09-16	9.7 (19)
96	3	369	1374	81	anddros	2008-11-22	8.8 (145)
199	3	15	1350	0	Baser	2013-08-17	8.3 (11)
76	3	372	1344	13	silver	2010-01-23	8.7 (147)
140	2	72	1315	2	_Bkmz_	2010-01-30	8.8 (36)
176	3	26	1307	0	qwrqwr	2011-05-20	9.4 (18)
182	3	18	1288	0	Baser	2011-10-29	8.1 (14)
85	3	307	1247	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	40	1189	4	vlksm	2009-01-05	9.7 (22)
93	3	118	1177	5	qwrqwr	2014-03-14	9.2 (52)
65	3	581	1177	41	Ozzy	2010-01-29	7.7 (209)
173	1	45	1172	2	Ozzy	2011-01-13	9.4 (23)
45	2	173	1164	22	dumkan	2016-04-03	7.6 (54)
82	3	320	1163	8	_Virt_	2010-04-27	8.2 (115)
84	3	355	1112	13	Ozzy	2009-12-26	8.3 (130)
134	3	168	1049	4	pvv	2008-01-22	8.6 (66)
68	3	178	1030	17	pegoopik	2014-08-01	8.1 (72)
158	3	32	1016	0	Ozzy	2010-04-09	8.8 (19)
51	2	275	1015	12	qwrqwr	2014-07-18	6.9 (85)
212	3	11	994	1	Baser	2014-10-14	8.8 (8)
37	3	496	983	21	qwrqwr	2013-02-22	8.2 (182)
168	2	34	945	1	qwrqwr	2010-08-27	9.6 (17)
99	3	150	943	9	Dmitrij Grinkevich	2012-05-05	7.9 (61)
71	3	452	833	19	anddros	2009-12-26	8.3 (155)
58	3	398	745	9	qwrqwr	2013-03-01	8.1 (148)
125	3	339	735	3	dimzv	2004-02-29	8.7 (81)
213	2	23	721	0	qwrqwr	2014-10-17	9.2 (13)
110	3	397	715	9	Snowbear	2006-03-14	8.9 (101)
251	4	63	634	3	paparome	2006-10-01	7.8 (25)
126	2	170	601	8	$erges	2008-09-07	8.5 (83)
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	52	554	1	Ozzy	2009-12-26	9.4 (30)
130	2	108	541	0	anddros	2010-05-22	8.8 (54)
64	3	450	513	42	qwrqwr	2010-05-13	7.8 (145)
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	551	449	49	anddros	2009-12-26	8.4 (213)
115	2	37	436	1	selber	2016-05-28	9.4 (17)
127	2	48	433	2	GriGrim	2014-12-21	7.3 (21)
166	1	53	431	2	anddros	2010-07-26	9.5 (26)
107	2	367	425	9	Fiolent	2004-02-26	8.2 (83)
23	3	1244	397	111	Palkin	2007-03-29	8.3 (294)
202	2	23	390	0	qwrqwr	2013-11-01	9.8 (12)
142	2	107	388	1	paparome	2007-03-24	9.0 (44)
177	1	47	372	0	pegoopik	2011-07-17	8.4 (23)
80	2	267	360	11	qwrqwr	2011-10-21	9.0 (107)
88	3	229	329	3	crescent	2011-03-23	8.8 (92)
254	1	39	325	2	Baser	2011-09-02	8.6 (22)
92	2	512	323	9	paparome	2006-07-26	8.4 (105)
36	3	766	321	18	risp	2011-05-06	7.9 (238)
209	1	27	319	1	Baser	2013-12-30	8.1 (11)
170	2	49	315	1	qwrqwr	2010-10-24	8.8 (24)
139	2	118	310	2	Snowbear	2006-09-09	8.2 (41)
41	3	885	298	20	qwrqwr	2010-04-26	7.9 (283)
47	3	724	298	15	qwrqwr	2010-11-20	7.9 (226)
60	3	1856	290	120	Serge I	2005-03-05	7.7 (270)
111	2	419	280	3	Fiolent	2005-01-19	8.3 (85)
54	2	1123	260	43	Ozzy	2008-09-06	8.2 (393)
118	2	396	242	1	Fiolent	2004-01-05	8.2 (77)
34	2	900	239	24	qwrqwr	2010-09-24	7.9 (280)
307	2	6	237	0	Baser	2017-06-29	9.3 (4)
29	2	788	234	33	GiBis	2011-09-17	7.3 (255)
67	2	468	232	16	Ozzy	2010-04-27	8.2 (165)
133	2	83	228	0	pickman	2011-07-01	8.2 (44)
105	2	99	224	0	Baser	2013-09-20	8.5 (39)
122	1	101	214	2	Dmitrij Grinkevich	2012-09-14	6.0 (45)
91	2	178	211	0	smog	2012-05-26	9.2 (71)
129	2	263	206	7	DimaN	2004-03-01	7.4 (54)
112	2	400	200	3	VIG	2005-06-26	7.5 (71)
43	2	271	200	2	qwrqwr	2015-04-24	8.4 (95)
131	2	82	198	1	GriGrim	2012-05-25	8.5 (39)
49	2	959	192	21	anddros	2009-06-05	7.8 (301)
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	1160	177	34	VIG	2003-09-01	8.0 (262)
61	2	760	170	4	risp	2009-12-26	8.5 (254)
86	2	289	170	0	Ozzy	2010-03-05	8.6 (97)
75	2	312	168	5	qwrqwr	2011-07-22	7.4 (111)
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	504	160	8	Dmitrij Grinkevich	2012-02-11	7.9 (166)
124	2	345	155	3	DimaN	2004-02-26	8.2 (76)
59	2	699	146	5	VIG	2003-12-22	8.4 (143)
74	2	585	143	8	vlksm	2008-06-21	8.2 (173)
16	2	527	142	51	qwrqwr	2014-07-18	7.5 (162)
203	1	33	139	1	=Maxim=	2013-10-05	9.5 (18)
109	2	456	138	1	VIG	2003-12-23	8.0 (83)
52	1	252	137	5	Serge I	2015-01-10	8.6 (84)
83	2	471	124	4	lepton	2006-09-29	8.4 (119)
94	2	208	120	1	pickman	2011-04-27	8.3 (75)
81	2	524	119	12	$erges	2008-05-10	8.1 (141)
38	2	768	118	22	ZrenBy	2003-09-01	7.8 (141)
78	2	342	115	3	_ORA_	2010-04-27	7.3 (105)
57	2	1642	112	14	Serge I	2005-05-07	7.7 (253)
35	3	276	111	5	Baser	2015-09-18	9.0 (88)
39	2	1132	109	16	Serge I	2003-08-28	7.5 (211)
201	2	33	109	0	Baser	2013-09-21	8.7 (20)
33	2	976	108	25	DimaN	2004-03-01	7.6 (283)
46	2	970	107	126	Serge I	2009-08-12	6.5 (264)
128	1	217	106	4	inkerman	2007-09-14	8.3 (68)
79	1	895	104	13	Serge I	2003-06-05	7.6 (130)
70	1	580	103	3	Serge I	2009-04-17	7.9 (187)
90	1	189	102	0	Dmitrij Grinkevich	2012-03-03	7.7 (66)
197	1	38	102	0	pegoopik	2013-06-10	8.6 (15)
103	1	101	101	1	Baser	2013-10-05	7.1 (42)
104	1	101	101	1	pegoopik	2013-07-19	8.3 (45)
73	1	373	98	2	Ruslan1707	2010-11-02	7.2 (117)
44	2	504	97	4	Serge I	2011-11-25	8.0 (163)
113	1	100	93	0	smog	2013-03-29	8.4 (44)
305	1	16	87	0	Baser	2017-01-06	9.5 (8)
114	1	418	86	4	Serge I	2003-12-24	8.4 (82)
69	1	577	86	1	mslava	2003-12-22	8.3 (118)
40	2	1911	84	74	Serge I	2003-04-08	7.7 (283)
50	2	1274	80	8	VIG	2003-04-29	8.2 (240)
25	2	928	77	27	DimaN	2004-06-22	6.9 (254)
24	2	1322	76	6	Aaz	2004-02-26	6.8 (383)
95	1	289	71	0	Fiolent	2004-06-23	8.0 (72)
17	2	948	69	4	vasia armor	2010-05-21	7.8 (272)
10	1	185	68	19	Serge I	2017-01-20	8.1 (76)
55	2	1172	68	72	Serge I	2008-06-21	7.5 (300)
32	1	1080	67	7	Roman Golubin	2005-12-13	7.5 (247)
26	1	1185	65	24	VIG	2003-12-22	7.7 (293)
21	1	874	59	6	paparome	2006-03-14	7.9 (206)
42	1	1384	59	15	Serge I	2003-06-05	7.5 (255)
97	1	322	58	4	dimzv	2004-03-01	7.7 (66)
117	1	398	56	0	Fiolent	2003-12-26	7.6 (74)
28	1	910	56	13	ZrenBy	2003-09-01	7.5 (166)
192	2	43	52	0	Baser	2012-03-03	9.2 (22)
256	1	34	50	1	anddros	2013-11-08	9.1 (17)
30	1	1473	50	4	Serge I	2003-08-28	7.7 (313)
18	1	1293	50	6	ZrenBy	2003-09-01	7.5 (283)
48	1	933	50	6	Serge I	2009-06-22	7.3 (246)
56	1	834	48	3	Fiolent	2004-06-22	7.8 (218)
31	1	753	48	6	Fiolent	2004-06-22	7.6 (182)
19	1	1669	47	19	Serge I	2004-06-23	7.4 (340)
27	1	979	46	8	Fiolent	2004-02-26	7.2 (225)
14	1	2084	45	35	Serge I	2003-04-08	7.4 (347)
108	1	459	45	0	mslava	2003-12-23	7.4 (80)
22	1	1302	44	9	ZrenBy	2003-09-01	7.1 (300)
12	1	2043	43	60	Serge I	2006-11-17	7.8 (356)
63	1	1128	42	5	VIG	2003-06-05	7.5 (184)
53	1	1244	42	25	DimaN	2004-03-01	7.5 (316)
302	0	34	36	0	pegoopik	2012-07-27	7.8 (9)
13	1	1352	35	18	ZrenBy	2003-09-01	7.3 (317)
11	1	1508	32	10	ZrenBy	2003-09-01	7.3 (336)
15	1	834	30	6	Dmitrij Grinkevich	2012-04-21	7.3 (242)
306	1	9	23	1	Serge I	2017-07-14	9.6 (7)
303	0	28	7	0	Serge I	2013-06-28	9.7 (13)
301	0	39	7	0	pegoopik	2012-03-23	8.8 (18)
258	3	21	3	1	Baser	2014-09-19	7.4 (7)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References