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

July 25, 23:50 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

  • About certification
  • The first certificate in SQL
  • Certified professionals
  • Statistics
  • Statistics over regions (map)
  • Confirm certificate

HELP

Query optimization

Transact-SQL tests

For employers

Support SQL-EX.RU

Poll

Would you get the following certificate?

Тренер по большому теннису в Москве зао
Новости тенниса. Товары для настольного тенниса
jprotennis.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	3	pegoopik	2015-08-28	9.3 (3)
147	4	23	15084	1	$erges	2010-08-06	9.8 (16)
157	3	21	13065	3	anddros	2009-06-05	9.5 (12)
143	5	42	11323	15	inkerman	2007-10-07	9.0 (28)
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	21	8713	2	vlksm	2009-04-17	10.0 (13)
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	1	pegoopik	2015-05-30	10.0 (6)
138	5	140	6385	32	Cyrilus	2005-12-09	9.1 (61)
178	3	19	5910	1	Baser	2011-08-13	8.9 (12)
181	4	12	5296	1	Ozzy	2011-10-08	10.0 (7)
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)
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	2	$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	69	3569	4	Velmont	2014-03-07	9.8 (37)
218	4	8	3491	2	al29	2016-04-04	10.0 (5)
116	5	210	3322	21	$erges	2008-12-13	9.3 (101)
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	204	3029	9	qwrqwr	2010-04-27	9.4 (104)
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	141	2868	5	GriGrim	2011-07-16	9.5 (66)
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)
101	4	173	2309	13	pegoopik	2010-11-20	9.4 (94)
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	68	2024	1	pegoopik	2014-02-14	8.8 (38)
145	3	63	1999	1	pvv	2008-01-07	8.5 (28)
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	6	vlksm	2008-09-06	9.2 (31)
141	4	69	1897	8	vlksm	2006-10-29	9.0 (28)
72	4	929	1882	149	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)
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)
179	3	14	1619	0	pegoopik	2011-09-17	9.0 (9)
137	4	184	1619	24	Cyrilus	2005-03-06	9.2 (63)
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	106	1492	5	Ozzy	2011-05-12	7.5 (44)
132	3	101	1489	4	risp	2010-01-25	7.7 (51)
175	3	24	1484	0	pegoopik	2011-04-28	8.4 (19)
106	3	243	1473	6	vlksm	2008-11-27	8.7 (103)
121	3	374	1471	4	ZrenBy	2004-02-26	7.8 (86)
123	3	212	1457	38	Ozzy	2009-08-22	9.0 (101)
200	3	14	1452	0	qwrqwr	2013-10-05	9.1 (9)
198	2	16	1444	0	Angellore	2013-09-13	9.3 (12)
169	3	26	1443	0	Valdaj	2010-09-02	8.4 (18)
215	2	15	1412	0	pegoopik	2015-03-06	8.9 (8)
77	2	218	1382	32	selber	2015-07-10	8.7 (92)
135	3	56	1376	1	qwrqwr	2013-04-19	9.1 (29)
180	3	26	1375	0	qwrqwr	2011-09-16	9.7 (19)
96	3	369	1374	81	anddros	2008-11-22	8.8 (145)
76	3	371	1356	13	silver	2010-01-23	8.7 (147)
199	3	15	1350	0	Baser	2013-08-17	8.3 (11)
140	2	71	1315	3	_Bkmz_	2010-01-30	8.8 (35)
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	306	1243	18	Ozzy	2009-10-10	8.4 (119)
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)
82	3	318	1187	7	_Virt_	2010-04-27	8.2 (115)
93	3	118	1177	5	qwrqwr	2014-03-14	9.2 (52)
65	3	580	1177	41	Ozzy	2010-01-29	7.7 (208)
173	1	45	1172	2	Ozzy	2011-01-13	9.4 (23)
84	3	354	1112	13	Ozzy	2009-12-26	8.3 (130)
223	2	6	1050	2	Baser	2016-11-12	10.0 (4)
134	3	167	1049	4	pvv	2008-01-22	8.6 (65)
51	2	272	1042	11	qwrqwr	2014-07-18	6.9 (85)
193	2	16	1040	1	Baser	2012-07-06	8.2 (11)
158	3	32	1016	0	Ozzy	2010-04-09	8.8 (19)
37	3	489	1009	22	qwrqwr	2013-02-22	8.2 (176)
212	3	11	994	1	Baser	2014-10-14	8.8 (8)
68	3	176	984	16	pegoopik	2014-08-01	8.2 (71)
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)
45	2	168	846	21	dumkan	2016-04-03	7.6 (50)
71	3	448	833	19	anddros	2009-12-26	8.3 (153)
58	3	394	745	10	qwrqwr	2013-03-01	8.1 (147)
213	2	23	721	0	qwrqwr	2014-10-17	9.2 (13)
110	3	395	715	9	Snowbear	2006-03-14	8.8 (99)
125	3	338	704	3	dimzv	2004-02-29	8.7 (80)
251	4	63	634	3	paparome	2006-10-01	7.8 (25)
126	2	169	601	8	$erges	2008-09-07	8.5 (82)
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)
130	2	107	559	0	anddros	2010-05-22	8.8 (53)
162	2	52	554	1	Ozzy	2009-12-26	9.4 (30)
64	3	449	513	41	qwrqwr	2010-05-13	7.8 (144)
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	550	449	49	anddros	2009-12-26	8.3 (212)
127	2	47	443	2	GriGrim	2014-12-21	7.3 (20)
115	2	35	436	1	selber	2016-05-28	9.3 (15)
166	1	53	431	2	anddros	2010-07-26	9.5 (26)
107	2	365	425	10	Fiolent	2004-02-26	8.1 (81)
23	3	1238	397	112	Palkin	2007-03-29	8.3 (291)
202	2	23	390	0	qwrqwr	2013-11-01	9.8 (12)
142	2	106	379	1	paparome	2007-03-24	9.0 (43)
177	1	47	372	0	pegoopik	2011-07-17	8.4 (23)
80	2	265	360	11	qwrqwr	2011-10-21	8.9 (106)
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	759	320	19	risp	2011-05-06	7.9 (234)
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)
47	3	721	298	14	qwrqwr	2010-11-20	7.9 (224)
60	3	1853	291	119	Serge I	2005-03-05	7.7 (268)
41	3	878	287	20	qwrqwr	2010-04-26	7.9 (278)
111	2	417	277	3	Fiolent	2005-01-19	8.3 (84)
54	2	1121	261	43	Ozzy	2008-09-06	8.2 (392)
118	2	393	242	1	Fiolent	2004-01-05	8.2 (76)
34	2	895	239	24	qwrqwr	2010-09-24	7.9 (277)
307	2	6	237	0	Baser	2017-06-29	9.3 (4)
29	2	783	234	34	GiBis	2011-09-17	7.3 (252)
67	2	465	232	18	Ozzy	2010-04-27	8.3 (163)
133	2	82	228	0	pickman	2011-07-01	8.1 (43)
105	2	98	224	0	Baser	2013-09-20	8.5 (38)
122	1	100	214	2	Dmitrij Grinkevich	2012-09-14	6.0 (44)
91	2	178	211	0	smog	2012-05-26	9.2 (71)
129	2	262	206	7	DimaN	2004-03-01	7.4 (53)
112	2	398	203	3	VIG	2005-06-26	7.5 (70)
131	2	81	198	1	GriGrim	2012-05-25	8.4 (38)
49	2	956	193	21	anddros	2009-06-05	7.8 (298)
43	2	261	192	3	qwrqwr	2015-04-24	8.4 (92)
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	1154	178	32	VIG	2003-09-01	8.0 (259)
75	2	311	178	4	qwrqwr	2011-07-22	7.4 (111)
61	2	757	170	4	risp	2009-12-26	8.4 (252)
86	2	289	170	0	Ozzy	2010-03-05	8.6 (97)
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	501	160	8	Dmitrij Grinkevich	2012-02-11	7.9 (164)
124	2	344	154	3	DimaN	2004-02-26	8.2 (75)
59	2	695	146	5	VIG	2003-12-22	8.4 (141)
74	2	583	143	8	vlksm	2008-06-21	8.2 (173)
16	2	518	140	53	qwrqwr	2014-07-18	7.5 (158)
203	1	33	139	1	=Maxim=	2013-10-05	9.5 (18)
109	2	454	138	1	VIG	2003-12-23	8.0 (82)
52	1	250	137	5	Serge I	2015-01-10	8.6 (83)
83	2	470	124	4	lepton	2006-09-29	8.4 (119)
94	2	208	120	1	pickman	2011-04-27	8.3 (75)
81	2	521	119	13	$erges	2008-05-10	8.1 (140)
78	2	341	116	3	_ORA_	2010-04-27	7.3 (105)
38	2	760	116	22	ZrenBy	2003-09-01	7.7 (137)
57	2	1639	112	15	Serge I	2005-05-07	7.7 (252)
35	3	270	111	5	Baser	2015-09-18	8.9 (86)
201	2	33	109	0	Baser	2013-09-21	8.7 (20)
33	2	971	108	25	DimaN	2004-03-01	7.6 (281)
39	2	1124	108	16	Serge I	2003-08-28	7.4 (205)
104	1	99	108	1	pegoopik	2013-07-19	8.3 (44)
46	2	966	107	126	Serge I	2009-08-12	6.4 (262)
128	1	216	106	4	inkerman	2007-09-14	8.3 (67)
79	1	894	104	13	Serge I	2003-06-05	7.6 (130)
70	1	577	103	3	Serge I	2009-04-17	7.9 (187)
103	1	99	103	1	Baser	2013-10-05	7.1 (41)
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)
225	2	2	100	1	pegoopik	2017-07-15	10.0 (1)
44	2	497	99	2	Serge I	2011-11-25	7.9 (160)
73	1	371	97	2	Ruslan1707	2010-11-02	7.2 (117)
113	1	98	93	0	smog	2013-03-29	8.5 (43)
114	1	416	87	4	Serge I	2003-12-24	8.4 (81)
305	1	16	87	0	Baser	2017-01-06	9.5 (8)
69	1	574	86	1	mslava	2003-12-22	8.3 (118)
40	2	1904	85	73	Serge I	2003-04-08	7.7 (280)
50	2	1271	80	8	VIG	2003-04-29	8.2 (237)
24	2	1316	76	6	Aaz	2004-02-26	6.8 (381)
25	2	920	76	29	DimaN	2004-06-22	6.9 (251)
95	1	289	71	0	Fiolent	2004-06-23	8.0 (72)
55	2	1170	69	72	Serge I	2008-06-21	7.5 (299)
17	2	937	68	4	vasia armor	2010-05-21	7.7 (267)
32	1	1075	67	7	Roman Golubin	2005-12-13	7.4 (245)
10	1	174	66	17	Serge I	2017-01-20	8.1 (72)
26	1	1180	65	21	VIG	2003-12-22	7.7 (291)
42	1	1376	59	16	Serge I	2003-06-05	7.5 (252)
21	1	868	58	6	paparome	2006-03-14	7.9 (204)
97	1	322	58	4	dimzv	2004-03-01	7.7 (66)
117	1	395	57	0	Fiolent	2003-12-26	7.6 (72)
28	1	905	56	12	ZrenBy	2003-09-01	7.5 (163)
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	1469	50	3	Serge I	2003-08-28	7.7 (310)
18	1	1285	50	4	ZrenBy	2003-09-01	7.5 (281)
48	1	930	50	6	Serge I	2009-06-22	7.3 (244)
56	1	832	48	3	Fiolent	2004-06-22	7.7 (217)
31	1	748	48	6	Fiolent	2004-06-22	7.6 (179)
19	1	1661	47	19	Serge I	2004-06-23	7.4 (337)
27	1	973	46	9	Fiolent	2004-02-26	7.2 (223)
108	1	457	45	0	mslava	2003-12-23	7.4 (79)
22	1	1297	44	9	ZrenBy	2003-09-01	7.1 (297)
14	1	2077	44	34	Serge I	2003-04-08	7.4 (345)
12	1	2036	43	59	Serge I	2006-11-17	7.8 (353)
63	1	1125	42	5	VIG	2003-06-05	7.5 (183)
53	1	1242	42	25	DimaN	2004-03-01	7.4 (315)
302	0	34	36	0	pegoopik	2012-07-27	7.8 (9)
13	1	1345	35	18	ZrenBy	2003-09-01	7.3 (315)
11	1	1501	32	10	ZrenBy	2003-09-01	7.3 (334)
15	1	827	30	6	Dmitrij Grinkevich	2012-04-21	7.4 (240)
306	1	8	23	0	Serge I	2017-07-14	9.7 (6)
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