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

SQL exercises

February 27, 09:21 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.

  • 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

  • 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

  • Learning stage
  • Rating stages
  • Favorites
  • Search
  • Blogs

Certification

  • Certified professionals
  • Statistics
  • Statistics over regions (map)
  • Confirm certificate

HELP

Query optimization

Developers & Thanks

For employers

Support SQL-EX.RU

Оливис магазин
оливис магазин
olivis.ru
Купить аккаунт фортнайт
купить по низкой цене! Поиск и сравнение цен
dimikey.com

Rating of second-stage exercises (average)

Rating of 2nd-stage exercises (median)

No - exercise number; Bonus - level of difficulty;
Solved - number of visitors, who have solved this exercise;
Time(min) - the average time (calculated over TOP 20) 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
254	1	45	190498	1	Baser	2011-09-02	8.8
211	2	14	173915	1	Baser	2014-06-30	9.8
223	2	12	171592	0	Baser	2016-11-12	9.9
217	4	9	113664	4	pegoopik	2015-08-28	9.2
159	3	17	88573	0	anddros	2012-07-22	8.2
251	4	68	74852	3	paparome	2006-10-01	8.0
214	4	11	73899	0	pegoopik	2015-05-30	10.0
175	3	30	71785	0	pegoopik	2011-04-28	8.5
190	4	16	70717	1	vlksm	2012-03-17	8.8
220	3	6	70495	1	pegoopik	2016-12-17	10.0
255	4	14	68481	3	vlksm	2012-02-14	9.8
252	2	34	67434	3	Ozzy	2009-06-14	8.3
178	3	22	67121	1	Baser	2011-08-13	9.1
101	4	208	66697	14	pegoopik	2010-11-20	9.4
102	4	175	64195	7	GriGrim	2011-07-16	9.4
172	3	21	63251	0	Ozzy	2011-03-11	9.7
304	2	24	63065	0	aks_nsk	2016-02-05	9.3
96	3	405	58462	81	anddros	2008-11-22	8.8
191	3	14	58423	0	qwrqwr	2012-06-08	9.5
143	5	44	57178	15	inkerman	2007-10-07	8.8
189	4	15	52225	0	Baser	2012-02-05	8.6
181	4	15	51625	1	Ozzy	2011-10-08	9.7
259	4	22	50526	2	anddros	2009-08-24	9.5
258	3	25	49820	0	Baser	2014-09-19	7.6
216	3	11	49497	1	pegoopik	2015-05-15	9.9
187	3	25	47200	0	=Maxim=	2011-12-31	8.8
169	3	30	45744	0	Valdaj	2010-09-02	8.4
138	5	145	44372	33	Cyrilus	2005-12-09	9.1
93	3	158	42786	5	qwrqwr	2014-03-14	9.3
173	1	52	40030	2	Ozzy	2011-01-13	9.3
253	3	30	39967	7	$erges	2008-05-17	8.9
165	2	30	38654	3	vlksm	2010-03-18	9.9
205	2	16	38349	0	qwrqwr	2013-11-22	8.9
194	4	15	37950	1	pegoopik	2012-07-13	10.0
261	1	35	37829	1	Fomichev	2013-12-07	7.0
120	4	96	37589	2	pegoopik	2014-02-14	8.9
99	3	187	35317	8	Dmitrij Grinkevich	2012-05-05	8.2
188	3	17	34385	1	qwrqwr	2012-02-04	9.8
148	2	65	32566	7	vlksm	2008-09-06	9.3
174	1	56	29937	0	qwrqwr	2011-02-25	9.3
157	3	24	28226	2	anddros	2009-06-05	9.6
212	3	16	27716	0	Baser	2014-10-14	8.9
92	2	548	27545	9	paparome	2006-07-26	8.5
49	2	1130	26758	22	anddros	2009-06-05	7.9
224	3	10	26714	0	selber	2017-04-14	9.4
163	3	19	26664	0	Ozzy	2010-01-08	9.6
160	3	26	25634	0	Ozzy	2009-08-07	9.6
154	4	25	23397	3	anddros	2009-03-18	9.9
186	1	37	23340	0	Ozzy	2011-12-30	9.2
149	3	34	21580	2	$erges	2008-09-08	9.2
161	3	21	21439	3	Ozzy	2009-11-06	9.2
119	5	99	20891	5	Velmont	2014-03-07	9.6
153	3	36	20110	4	Ozzy	2009-02-14	9.5
116	5	238	19494	20	$erges	2008-12-13	9.3
126	2	179	18693	11	$erges	2008-09-07	8.6
150	4	36	18162	4	@Nikotin	2008-11-09	8.5
147	4	26	18075	2	$erges	2010-08-06	9.7
171	3	19	17760	1	Ozzy	2010-12-05	9.3
122	1	127	16023	2	Dmitrij Grinkevich	2012-09-14	6.0
184	2	25	15219	2	Baser	2011-11-26	8.8
176	3	31	14985	0	qwrqwr	2011-05-20	9.5
156	2	51	14817	3	anddros	2009-04-17	9.1
151	3	32	13744	5	anddros	2008-12-30	8.9
19	1	1926	13539	23	Serge I	2004-06-23	7.5
145	3	69	11864	1	pvv	2008-01-07	8.6
62	2	665	11588	10	Dmitrij Grinkevich	2012-02-11	8.0
193	2	22	11370	0	Baser	2012-07-06	8.3
164	2	37	11169	1	anddros	2010-04-26	9.7
106	3	275	10702	5	vlksm	2008-11-27	8.8
100	4	240	10440	11	qwrqwr	2010-04-27	9.4
215	2	23	10440	0	pegoopik	2015-03-06	9.3
206	4	14	9282	0	Baser	2013-11-23	9.1
230	2	7	9143	1	pegoopik	2018-07-27	9.8
210	2	15	9016	0	_dimon_	2014-02-07	10.0
183	2	30	9016	2	GriGrim	2011-11-12	9.1
218	4	12	8905	2	al29	2016-04-04	9.6
257	4	17	8812	1	pegoopik	2012-02-20	9.4
208	3	14	8424	0	pegoopik	2013-12-20	8.8
115	2	71	8174	1	selber	2016-05-28	9.1
225	2	10	7677	0	pegoopik	2017-07-15	9.8
139	2	125	7537	2	Snowbear	2006-09-09	8.3
155	3	26	7331	2	vlksm	2009-04-17	9.9
144	4	44	6638	4	pvv	2008-01-01	7.3
141	4	79	6558	9	vlksm	2006-10-29	9.0
200	3	18	6532	0	qwrqwr	2013-10-05	9.3
137	4	190	6428	24	Cyrilus	2005-03-06	9.2
152	3	46	6401	4	vlksm	2009-01-05	9.7
180	3	32	6342	0	qwrqwr	2011-09-16	9.6
77	2	290	6212	31	selber	2015-07-10	8.7
234	3	3	6045	1	Kursist	2020-02-28	9.5
229	3	6	5490	1	al29	2018-03-23	9.6
198	2	23	5228	0	Angellore	2013-09-13	9.4
227	3	9	5136	1	mcrain	2017-12-08	7.0
179	3	17	4926	0	pegoopik	2011-09-17	9.2
231	3	5	4923	0	mcrain	2018-08-24	10.0
123	3	236	4724	39	Ozzy	2009-08-22	9.0
45	2	388	4707	17	dumkan	2016-04-03	8.0
140	2	81	4518	2	_Bkmz_	2010-01-30	8.9
168	2	42	4507	2	qwrqwr	2010-08-27	9.5
213	2	26	4445	0	qwrqwr	2014-10-17	9.6
121	3	398	4424	4	ZrenBy	2004-02-26	7.8
133	2	89	4324	0	pickman	2011-07-01	8.2
132	3	108	4322	4	risp	2010-01-25	7.6
26	1	1418	3993	24	VIG	2003-12-22	7.7
182	3	23	3548	0	Baser	2011-10-29	8.1
158	3	38	3320	0	Ozzy	2010-04-09	8.9
222	2	12	3316	1	pegoopik	2016-12-23	9.8
233	1	13	3277	1	pegoopik	2019-03-08	10.0
135	3	63	3181	1	qwrqwr	2013-04-19	8.9
232	3	5	3110	0	al29	2018-08-20	10.0
65	3	681	3058	46	Ozzy	2010-01-29	7.8
131	2	88	2994	1	GriGrim	2012-05-25	8.5
72	4	1001	2891	150	paparome	2005-12-03	9.2
107	2	398	2864	9	Fiolent	2004-02-26	8.1
167	3	24	2850	0	qwrqwr	2011-01-18	9.9
207	3	16	2850	0	pegoopik	2016-01-15	10.0
98	4	574	2770	44	ZrenBy	2003-09-01	8.2
221	2	16	2706	0	Baser	2016-11-05	8.9
87	4	624	2653	90	Roman Golubin	2006-07-14	9.3
256	1	39	2460	1	anddros	2013-11-08	8.9
89	3	403	2414	29	_Bkmz_	2008-06-21	7.8
185	1	43	2363	3	=Maxim=	2011-11-25	7.9
302	0	37	2328	0	pegoopik	2012-07-27	7.6
136	3	112	2306	5	Ozzy	2011-05-12	7.4
146	3	60	2262	3	paparome	2008-01-22	9.7
209	1	33	2078	1	Baser	2013-12-30	8.0
228	1	18	2048	1	qwrqwr	2018-01-12	10.0
219	2	16	1991	0	pegoopik	2016-04-08	9.9
199	3	20	1981	0	Baser	2013-08-17	8.4
204	1	34	1878	1	anddros	2013-11-19	8.7
166	1	59	1865	2	anddros	2010-07-26	9.6
195	3	26	1775	0	Dmitrij Grinkevich	2013-04-20	9.1
71	3	523	1700	20	anddros	2009-12-26	8.4
76	3	435	1637	17	silver	2010-01-23	8.8
196	3	25	1616	0	qwrqwr	2013-05-17	9.4
125	3	362	1609	3	dimzv	2004-02-29	8.7
58	3	572	1540	10	qwrqwr	2013-03-01	8.2
127	2	55	1441	2	GriGrim	2014-12-21	7.7
130	2	115	1434	0	anddros	2010-05-22	8.8
85	3	354	1434	18	Ozzy	2009-10-10	8.5
20	2	1422	1412	35	VIG	2003-09-01	8.0
142	2	114	1377	1	paparome	2007-03-24	9.0
84	3	402	1308	17	Ozzy	2009-12-26	8.4
134	3	173	1242	4	pvv	2008-01-22	8.6
226	3	9	1236	2	pegoopik	2017-10-14	9.2
111	2	446	1232	3	Fiolent	2005-01-19	8.3
105	2	132	1206	0	Baser	2013-09-20	8.5
197	1	43	1185	0	pegoopik	2013-06-10	8.8
64	3	566	1169	48	qwrqwr	2010-05-13	7.9
162	2	59	1167	0	Ozzy	2009-12-26	9.3
88	3	270	1166	6	crescent	2011-03-23	8.9
110	3	424	1166	11	Snowbear	2006-03-14	8.8
203	1	40	1137	1	=Maxim=	2013-10-05	9.4
307	2	19	1120	0	Baser	2017-06-29	8.5
80	2	327	1098	10	qwrqwr	2011-10-21	8.9
177	1	53	1004	0	pegoopik	2011-07-17	8.5
170	2	54	982	1	qwrqwr	2010-10-24	9.0
124	2	368	970	3	DimaN	2004-02-26	8.3
66	3	640	954	53	anddros	2009-12-26	8.4
32	1	1297	921	7	Roman Golubin	2005-12-13	7.5
260	2	52	913	0	qwrqwr	2012-02-03	7.7
202	2	29	911	0	qwrqwr	2013-11-01	9.1
114	1	444	901	4	Serge I	2003-12-24	8.4
40	1	236	899	13	Serge I	2018-09-07	7.0
201	2	38	806	0	Baser	2013-09-21	8.7
129	2	270	769	7	DimaN	2004-03-01	7.5
305	1	25	732	0	Baser	2017-01-06	9.0
23	3	1488	690	121	Palkin	2007-03-29	8.4
43	2	472	689	3	qwrqwr	2015-04-24	8.5
91	2	215	672	1	smog	2012-05-26	9.1
192	2	48	608	0	Baser	2012-03-03	9.2
103	1	133	599	1	Baser	2013-10-05	7.3
82	3	373	590	12	_Virt_	2010-04-27	8.2
118	2	420	560	1	Fiolent	2004-01-05	8.2
75	2	382	559	4	qwrqwr	2011-07-22	7.4
67	2	555	556	17	Ozzy	2010-04-27	8.3
68	3	267	537	24	pegoopik	2014-08-01	8.0
47	3	899	518	16	qwrqwr	2010-11-20	8.1
60	3	2018	515	120	Serge I	2005-03-05	7.8
54	2	1291	507	45	Ozzy	2008-09-06	8.2
37	3	703	500	27	qwrqwr	2013-02-22	8.0
41	3	1069	488	17	qwrqwr	2010-04-26	8.1
79	1	953	485	14	Serge I	2003-06-05	7.7
69	2	145	462	8	Gosha	2017-12-15	9.0
35	3	513	421	10	Baser	2015-09-18	8.8
262	2	11	405	0	selber	2019-06-21	6.5
50	1	777	399	5	mslava	2003-12-22	8.3
86	2	336	390	0	Ozzy	2010-03-05	8.6
109	2	486	385	2	VIG	2003-12-23	7.9
78	2	403	358	3	_ORA_	2010-04-27	7.4
51	1	506	358	14	Fiolent	2004-06-23	8.1
59	2	870	327	5	VIG	2003-12-22	8.3
63	1	1288	324	5	VIG	2003-06-05	7.6
73	1	441	322	3	Ruslan1707	2010-11-02	7.4
38	2	972	319	24	ZrenBy	2003-09-01	7.6
34	2	1113	316	27	qwrqwr	2010-09-24	7.9
90	1	227	316	0	Dmitrij Grinkevich	2012-03-03	7.8
44	2	683	289	8	Serge I	2011-11-25	7.9
61	2	920	286	5	risp	2009-12-26	8.5
12	1	304	280	41	Serge I	2019-04-12	7.2
25	2	1165	275	30	DimaN	2004-06-22	7.0
97	1	359	271	3	dimzv	2004-03-01	7.7
74	2	651	268	8	vlksm	2008-06-21	8.3
46	2	1145	257	126	Serge I	2009-08-12	6.7
104	1	133	247	0	pegoopik	2013-07-19	8.4
113	1	128	227	0	smog	2013-03-29	8.4
33	2	1194	225	24	DimaN	2004-03-01	7.6
128	1	224	224	4	inkerman	2007-09-14	8.3
55	2	485	219	7	VIG	2005-06-26	7.6
6	2	1847	212	24	Serge I	2005-05-07	7.9
17	2	1571	208	22	VIG	2003-04-29	8.1
95	1	84	208	2	qwrqwr	2017-12-01	9.3
83	2	522	173	4	lepton	2006-09-29	8.5
18	1	1560	173	6	ZrenBy	2003-09-01	7.6
70	1	652	169	3	Serge I	2009-04-17	7.8
9	2	1309	168	28	vasia armor	2010-05-21	7.9
303	2	10	166	0	MikhailYakovlev535	2020-06-23	5.7
108	1	490	155	0	mslava	2003-12-23	7.3
94	2	246	153	0	pickman	2011-04-27	8.2
112	1	23	149	2	Gosha	2020-06-03	9.0
30	1	1688	138	3	Serge I	2003-08-28	7.9
81	2	582	136	12	$erges	2008-05-10	8.2
56	1	1003	126	3	Fiolent	2004-06-22	7.9
52	1	445	125	3	Serge I	2015-01-10	8.7
36	3	975	122	20	risp	2011-05-06	8.0
16	2	829	116	60	qwrqwr	2014-07-18	7.4
42	1	1567	110	14	Serge I	2003-06-05	7.7
21	1	1134	105	9	paparome	2006-03-14	8.0
13	1	1652	99	21	ZrenBy	2003-09-01	7.5
39	2	1324	98	20	Serge I	2003-08-28	7.5
53	1	1415	98	25	DimaN	2004-03-01	7.6
57	1	54	94	9	Kursist	2020-10-10	9.7
28	1	1143	94	13	ZrenBy	2003-09-01	7.6
14	1	2373	88	36	Serge I	2003-04-08	7.5
24	2	1557	86	6	Aaz	2004-02-26	6.9
29	2	1012	82	42	GiBis	2011-09-17	7.5
31	1	975	64	7	Fiolent	2004-06-22	7.9
117	1	422	57	0	Fiolent	2003-12-26	7.6
8	2	1381	50	88	Serge I	2008-06-21	7.6
48	1	1105	43	6	Serge I	2009-06-22	7.4
235	1	2	43	0	Baser	2021-02-27	10.0
11	1	1824	42	15	ZrenBy	2003-09-01	7.5
22	1	1552	40	12	ZrenBy	2003-09-01	7.3
27	1	1213	36	8	Fiolent	2004-02-26	7.3
7	1	2436	32	78	Serge I	2006-11-17	7.9
10	1	635	25	45	Serge I	2017-01-20	8.0
15	1	1134	24	9	Dmitrij Grinkevich	2012-04-21	7.5
301	0	43	7	0	pegoopik	2012-03-23	8.9
306	1	3	5	0	Baser	2021-02-26	8.0

Home
Week news

Certification

SQL exercises

HELP

Performance

Profile
References

Copyright SQL-EX © 2002-2021. All rights reserved.
contact