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

September 24, 01:27 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
  • 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)
206	4	13	6127	0	Baser	2013-11-23	9.0 (11)
225	2	9	6053	0	pegoopik	2017-07-15	9.8 (6)
231	2	2	5903	1	mcrain	2018-08-24	10.0 (1)
230	2	6	5717	0	pegoopik	2018-07-27	9.8 (4)
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	12	4638	2	Baser	2014-06-30	9.8 (8)
255	4	12	4399	4	vlksm	2012-02-14	9.9 (7)
220	3	6	4388	1	pegoopik	2016-12-17	10.0 (3)
232	3	3	4384	0	al29	2018-08-20	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	33	3909	2	$erges	2008-09-08	9.2 (21)
172	3	20	3717	0	Ozzy	2011-03-11	9.7 (14)
257	4	14	3710	1	pegoopik	2012-02-20	9.5 (11)
116	5	222	3492	21	$erges	2008-12-13	9.3 (104)
218	4	11	3491	1	al29	2016-04-04	9.6 (7)
178	3	21	3302	1	Baser	2011-08-13	9.0 (14)
119	5	82	3203	5	Velmont	2014-03-07	9.7 (43)
188	3	15	3191	1	qwrqwr	2012-02-04	9.7 (11)
171	3	18	3174	1	Ozzy	2010-12-05	9.3 (14)
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)
100	4	222	2980	9	qwrqwr	2010-04-27	9.3 (110)
144	4	41	2928	3	pvv	2008-01-01	7.3 (25)
102	4	157	2786	6	GriGrim	2011-07-16	9.5 (71)
120	4	81	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)
153	3	34	2481	4	Ozzy	2009-02-14	9.4 (19)
179	3	17	2329	0	pegoopik	2011-09-17	9.2 (12)
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	189	2102	15	pegoopik	2010-11-20	9.4 (100)
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)
98	4	553	1912	44	ZrenBy	2003-09-01	8.1 (117)
148	2	64	1910	7	vlksm	2008-09-06	9.3 (35)
72	4	950	1868	149	paparome	2005-12-03	9.2 (243)
87	4	599	1787	85	Roman Golubin	2006-07-14	9.3 (161)
182	3	21	1717	0	Baser	2011-10-29	8.1 (16)
205	2	14	1707	0	qwrqwr	2013-11-22	8.8 (9)
89	3	381	1707	29	_Bkmz_	2008-06-21	7.9 (138)
187	3	22	1686	1	=Maxim=	2011-12-31	8.6 (18)
137	4	187	1632	24	Cyrilus	2005-03-06	9.2 (66)
165	2	29	1631	3	vlksm	2010-03-18	9.9 (18)
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	4	GriGrim	2011-11-12	9.0 (14)
132	3	103	1489	5	risp	2010-01-25	7.7 (53)
121	3	384	1486	4	ZrenBy	2004-02-26	7.8 (89)
175	3	28	1484	1	pegoopik	2011-04-28	8.5 (21)
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)
150	4	33	1442	4	@Nikotin	2008-11-09	8.7 (19)
198	2	19	1440	0	Angellore	2013-09-13	9.4 (14)
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)
228	1	12	1363	2	qwrqwr	2018-01-12	10.0 (8)
96	3	384	1354	81	anddros	2008-11-22	8.8 (150)
176	3	28	1341	0	qwrqwr	2011-05-20	9.5 (20)
76	3	394	1338	12	silver	2010-01-23	8.8 (156)
77	2	241	1327	34	selber	2015-07-10	8.7 (101)
106	3	257	1322	6	vlksm	2008-11-27	8.8 (108)
207	3	12	1255	0	pegoopik	2016-01-15	10.0 (8)
85	3	323	1247	17	Ozzy	2009-10-10	8.5 (126)
226	3	8	1235	1	pegoopik	2017-10-14	9.2 (5)
69	2	70	1223	6	Gosha	2017-12-15	9.4 (30)
82	3	337	1201	8	_Virt_	2010-04-27	8.1 (124)
45	2	230	1194	25	dumkan	2016-04-03	7.8 (73)
65	3	605	1178	40	Ozzy	2010-01-29	7.7 (219)
93	3	136	1166	5	qwrqwr	2014-03-14	9.3 (58)
140	2	78	1126	2	_Bkmz_	2010-01-30	8.9 (40)
68	3	204	1092	17	pegoopik	2014-08-01	8.2 (82)
134	3	170	1049	3	pvv	2008-01-22	8.6 (68)
84	3	369	1008	16	Ozzy	2009-12-26	8.3 (135)
37	3	547	983	22	qwrqwr	2013-02-22	8.0 (204)
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	470	786	18	anddros	2009-12-26	8.3 (164)
125	3	350	735	3	dimzv	2004-02-29	8.7 (82)
58	3	438	729	10	qwrqwr	2013-03-01	8.1 (163)
213	2	24	721	0	qwrqwr	2014-10-17	9.1 (14)
110	3	408	707	10	Snowbear	2006-03-14	8.8 (102)
99	3	166	706	8	Dmitrij Grinkevich	2012-05-05	7.9 (64)
126	2	174	627	9	$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	40	573	3	=Maxim=	2011-11-25	8.2 (24)
162	2	57	554	1	Ozzy	2009-12-26	9.3 (34)
64	3	477	543	48	qwrqwr	2010-05-13	7.8 (152)
130	2	110	541	0	anddros	2010-05-22	8.8 (55)
202	2	25	504	0	qwrqwr	2013-11-01	9.8 (13)
174	1	54	489	0	qwrqwr	2011-02-25	9.3 (32)
66	3	571	477	51	anddros	2009-12-26	8.4 (218)
127	2	50	443	2	GriGrim	2014-12-21	7.5 (22)
115	2	53	436	1	selber	2016-05-28	9.3 (21)
107	2	380	425	9	Fiolent	2004-02-26	8.2 (87)
307	2	17	421	0	Baser	2017-06-29	8.4 (10)
23	3	1305	397	114	Palkin	2007-03-29	8.4 (312)
142	2	112	388	1	paparome	2007-03-24	9.0 (47)
177	1	51	372	0	pegoopik	2011-07-17	8.4 (25)
80	2	286	364	10	qwrqwr	2011-10-21	8.9 (113)
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	21	333	0	pegoopik	2015-03-06	9.3 (12)
170	2	52	332	1	qwrqwr	2010-10-24	9.0 (26)
139	2	123	332	2	Snowbear	2006-09-09	8.3 (44)
88	3	246	329	3	crescent	2011-03-23	8.8 (98)
36	3	814	321	18	risp	2011-05-06	7.9 (256)
209	1	31	319	1	Baser	2013-12-30	7.9 (14)
92	2	527	311	9	paparome	2006-07-26	8.4 (110)
47	3	766	299	14	qwrqwr	2010-11-20	8.0 (242)
41	3	928	287	19	qwrqwr	2010-04-26	7.9 (300)
60	3	1895	285	119	Serge I	2005-03-05	7.7 (283)
111	2	430	277	3	Fiolent	2005-01-19	8.2 (86)
54	2	1162	258	45	Ozzy	2008-09-06	8.2 (408)
29	2	843	253	38	GiBis	2011-09-17	7.4 (275)
34	2	949	242	24	qwrqwr	2010-09-24	7.9 (299)
118	2	405	242	1	Fiolent	2004-01-05	8.2 (78)
204	1	32	232	1	anddros	2013-11-19	8.6 (16)
133	2	84	228	0	pickman	2011-07-01	8.2 (45)
67	2	487	227	16	Ozzy	2010-04-27	8.3 (170)
105	2	113	219	1	Baser	2013-09-20	8.6 (42)
91	2	193	218	0	smog	2012-05-26	9.1 (77)
122	1	112	217	2	Dmitrij Grinkevich	2012-09-14	5.9 (47)
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)
43	2	323	190	2	qwrqwr	2015-04-24	8.4 (114)
49	2	999	186	22	anddros	2009-06-05	7.8 (315)
75	2	334	185	4	qwrqwr	2011-07-22	7.5 (119)
260	2	50	183	0	qwrqwr	2012-02-03	7.6 (33)
20	2	1228	182	32	VIG	2003-09-01	8.0 (282)
86	2	305	169	0	Ozzy	2010-03-05	8.6 (102)
261	1	33	169	1	Fomichev	2013-12-07	6.8 (18)
95	1	54	166	2	qwrqwr	2017-12-01	9.2 (26)
16	2	606	166	58	qwrqwr	2014-07-18	7.4 (189)
61	2	798	166	5	risp	2009-12-26	8.4 (268)
62	2	543	165	8	Dmitrij Grinkevich	2012-02-11	7.9 (177)
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	740	148	4	VIG	2003-12-22	8.5 (155)
74	2	604	142	8	vlksm	2008-06-21	8.3 (181)
109	2	469	137	1	VIG	2003-12-23	8.0 (86)
52	1	302	136	3	Serge I	2015-01-10	8.6 (99)
38	2	817	126	21	ZrenBy	2003-09-01	7.7 (155)
83	2	489	120	4	lepton	2006-09-29	8.4 (128)
94	2	224	120	0	pickman	2011-04-27	8.2 (81)
35	3	337	119	10	Baser	2015-09-18	8.9 (111)
201	2	36	119	0	Baser	2013-09-21	8.7 (22)
81	2	541	118	13	$erges	2008-05-10	8.2 (149)
78	2	362	115	3	_ORA_	2010-04-27	7.4 (113)
39	2	1175	114	18	Serge I	2003-08-28	7.5 (224)
33	2	1028	109	23	DimaN	2004-03-01	7.6 (301)
57	2	1681	108	14	Serge I	2005-05-07	7.7 (264)
197	1	42	107	0	pegoopik	2013-06-10	8.8 (19)
128	1	219	106	4	inkerman	2007-09-14	8.3 (69)
104	1	116	104	0	pegoopik	2013-07-19	8.3 (50)
46	2	1010	104	126	Serge I	2009-08-12	6.6 (278)
79	1	913	104	15	Serge I	2003-06-05	7.6 (137)
44	2	547	104	4	Serge I	2011-11-25	7.9 (182)
70	1	597	102	3	Serge I	2009-04-17	7.9 (194)
90	1	204	102	0	Dmitrij Grinkevich	2012-03-03	7.7 (71)
305	1	23	101	0	Baser	2017-01-06	8.8 (12)
73	1	392	98	2	Ruslan1707	2010-11-02	7.4 (125)
113	1	111	91	0	smog	2013-03-29	8.4 (46)
50	1	627	90	11	mslava	2003-12-22	8.3 (133)
10	1	334	87	32	Serge I	2017-01-20	8.1 (120)
103	1	116	86	1	Baser	2013-10-05	7.2 (46)
114	1	428	83	4	Serge I	2003-12-24	8.3 (83)
40	2	1953	83	74	Serge I	2003-04-08	7.7 (300)
17	2	1352	82	20	VIG	2003-04-29	8.1 (262)
51	1	360	79	8	Fiolent	2004-06-23	7.9 (95)
25	2	982	78	32	DimaN	2004-06-22	6.9 (269)
24	2	1379	76	6	Aaz	2004-02-26	6.8 (398)
256	1	38	74	1	anddros	2013-11-08	8.9 (19)
9	2	1041	72	12	vasia armor	2010-05-21	7.8 (308)
26	1	1242	69	20	VIG	2003-12-22	7.8 (307)
55	2	1211	67	72	Serge I	2008-06-21	7.5 (313)
32	1	1131	66	8	Roman Golubin	2005-12-13	7.5 (260)
28	1	968	61	11	ZrenBy	2003-09-01	7.5 (180)
21	1	940	61	8	paparome	2006-03-14	8.0 (220)
97	1	338	59	3	dimzv	2004-03-01	7.7 (71)
42	1	1428	58	14	Serge I	2003-06-05	7.6 (270)
117	1	407	55	0	Fiolent	2003-12-26	7.6 (75)
306	1	7	55	0	Serge I	2018-09-07	9.2 (5)
192	2	46	52	0	Baser	2012-03-03	9.1 (24)
48	1	974	52	6	Serge I	2009-06-22	7.3 (258)
18	1	1361	51	6	ZrenBy	2003-09-01	7.5 (303)
30	1	1525	50	3	Serge I	2003-08-28	7.8 (329)
31	1	807	48	7	Fiolent	2004-06-22	7.7 (198)
27	1	1035	48	9	Fiolent	2004-02-26	7.2 (239)
56	1	873	48	3	Fiolent	2004-06-22	7.8 (229)
19	1	1731	47	21	Serge I	2004-06-23	7.4 (355)
14	1	2155	46	36	Serge I	2003-04-08	7.4 (367)
108	1	472	46	0	mslava	2003-12-23	7.4 (83)
22	1	1363	45	11	ZrenBy	2003-09-01	7.2 (318)
302	0	35	45	0	pegoopik	2012-07-27	7.7 (10)
12	1	2118	43	59	Serge I	2006-11-17	7.9 (385)
63	1	1167	42	5	VIG	2003-06-05	7.4 (196)
53	1	1285	41	25	DimaN	2004-03-01	7.5 (329)
13	1	1427	37	19	ZrenBy	2003-09-01	7.3 (338)
11	1	1585	33	13	ZrenBy	2003-09-01	7.4 (361)
15	1	914	31	5	Dmitrij Grinkevich	2012-04-21	7.4 (265)
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