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

SQL exercises

July 27, 12:55 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 (SELECT)
  • Exercises voting (DML)

  • 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
Облачный сервер
выделенных серверов за границей
skalex.net

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
234	3	4	142013	1	Kursist	2020-02-28	9.5
217	4	9	113664	4	pegoopik	2015-08-28	9.2
159	3	17	88573	1	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
101	4	210	66697	14	pegoopik	2010-11-20	9.4
178	3	23	64295	1	Baser	2011-08-13	9.1
102	4	177	64195	7	GriGrim	2011-07-16	9.5
304	2	24	63065	0	aks_nsk	2016-02-05	9.3
172	3	22	59687	0	Ozzy	2011-03-11	9.8
96	3	406	58462	81	anddros	2008-11-22	8.8
191	3	14	58423	0	qwrqwr	2012-06-08	9.5
143	5	45	57178	14	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	159	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	100	37589	3	pegoopik	2014-02-14	8.9
99	3	189	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	549	27545	9	paparome	2006-07-26	8.5
49	2	1140	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	27	24342	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	104	20891	4	Velmont	2014-03-07	9.6
153	3	36	20110	4	Ozzy	2009-02-14	9.5
116	5	242	19494	20	$erges	2008-12-13	9.4
126	2	180	18693	11	$erges	2008-09-07	8.5
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	131	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
19	1	1938	13539	23	Serge I	2004-06-23	7.5
151	3	33	13131	5	anddros	2008-12-30	8.9
145	3	69	11864	1	pvv	2008-01-07	8.6
62	2	675	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	278	10702	5	vlksm	2008-11-27	8.8
100	4	242	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	75	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	45	6638	4	pvv	2008-01-01	7.2
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	294	6212	32	selber	2015-07-10	8.8
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	240	4724	39	Ozzy	2009-08-22	9.0
45	2	398	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	402	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	1428	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	688	3058	46	Ozzy	2010-01-29	7.7
131	2	88	2994	1	GriGrim	2012-05-25	8.5
72	4	1006	2891	150	paparome	2005-12-03	9.2
107	2	401	2864	9	Fiolent	2004-02-26	8.2
167	3	24	2850	0	qwrqwr	2011-01-18	9.9
207	3	16	2850	0	pegoopik	2016-01-15	10.0
98	4	576	2770	44	ZrenBy	2003-09-01	8.2
221	2	16	2706	1	Baser	2016-11-05	8.9
87	4	625	2653	91	Roman Golubin	2006-07-14	9.3
256	1	39	2460	1	anddros	2013-11-08	8.9
89	3	404	2414	30	_Bkmz_	2008-06-21	7.9
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	528	1700	20	anddros	2009-12-26	8.4
76	3	441	1637	16	silver	2010-01-23	8.8
196	3	25	1616	0	qwrqwr	2013-05-17	9.4
125	3	366	1609	3	dimzv	2004-02-29	8.7
58	3	581	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	356	1434	20	Ozzy	2009-10-10	8.5
20	2	1434	1412	35	VIG	2003-09-01	8.0
142	2	114	1377	1	paparome	2007-03-24	9.0
84	3	408	1308	16	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	450	1232	3	Fiolent	2005-01-19	8.3
105	2	135	1206	0	Baser	2013-09-20	8.5
197	1	43	1185	0	pegoopik	2013-06-10	8.8
64	3	573	1169	47	qwrqwr	2010-05-13	8.0
162	2	59	1167	0	Ozzy	2009-12-26	9.3
88	3	272	1166	5	crescent	2011-03-23	8.9
110	3	428	1166	11	Snowbear	2006-03-14	8.9
203	1	40	1137	1	=Maxim=	2013-10-05	9.4
307	2	19	1120	0	Baser	2017-06-29	8.5
80	2	332	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	372	970	3	DimaN	2004-02-26	8.3
66	3	646	954	54	anddros	2009-12-26	8.5
32	1	1309	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	448	901	4	Serge I	2003-12-24	8.4
40	1	249	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	1498	690	122	Palkin	2007-03-29	8.3
43	2	482	689	4	qwrqwr	2015-04-24	8.5
91	2	216	672	1	smog	2012-05-26	9.1
192	2	48	608	0	Baser	2012-03-03	9.2
103	1	136	599	1	Baser	2013-10-05	7.4
82	3	379	590	11	_Virt_	2010-04-27	8.2
118	2	424	560	1	Fiolent	2004-01-05	8.2
75	2	387	559	4	qwrqwr	2011-07-22	7.5
67	2	561	556	16	Ozzy	2010-04-27	8.3
68	3	272	537	25	pegoopik	2014-08-01	8.1
47	3	909	518	15	qwrqwr	2010-11-20	8.1
60	3	2028	515	119	Serge I	2005-03-05	7.8
54	2	1301	507	46	Ozzy	2008-09-06	8.2
37	3	717	500	25	qwrqwr	2013-02-22	8.0
41	3	1078	488	18	qwrqwr	2010-04-26	8.1
79	1	957	485	14	Serge I	2003-06-05	7.7
69	2	151	462	7	Gosha	2017-12-15	9.0
35	3	526	421	11	Baser	2015-09-18	8.8
262	2	11	405	0	selber	2019-06-21	6.5
50	1	789	399	4	mslava	2003-12-22	8.3
86	2	338	390	0	Ozzy	2010-03-05	8.6
109	2	490	385	1	VIG	2003-12-23	8.0
78	2	407	358	3	_ORA_	2010-04-27	7.5
51	1	518	358	14	Fiolent	2004-06-23	8.1
59	2	879	327	5	VIG	2003-12-22	8.3
63	1	1297	324	6	VIG	2003-06-05	7.6
73	1	446	322	3	Ruslan1707	2010-11-02	7.4
38	2	985	319	24	ZrenBy	2003-09-01	7.6
34	2	1124	316	26	qwrqwr	2010-09-24	7.9
90	1	228	316	0	Dmitrij Grinkevich	2012-03-03	7.8
44	2	694	289	8	Serge I	2011-11-25	7.9
61	2	929	286	6	risp	2009-12-26	8.4
12	1	328	280	46	Serge I	2019-04-12	7.2
25	2	1176	275	29	DimaN	2004-06-22	7.0
97	1	361	271	3	dimzv	2004-03-01	7.7
74	2	657	268	8	vlksm	2008-06-21	8.3
46	2	1154	257	126	Serge I	2009-08-12	6.7
104	1	136	247	0	pegoopik	2013-07-19	8.4
113	1	132	227	0	smog	2013-03-29	8.5
33	2	1205	225	26	DimaN	2004-03-01	7.6
128	1	224	224	4	inkerman	2007-09-14	8.3
55	2	511	219	7	VIG	2005-06-26	7.6
6	2	1889	212	36	Serge I	2005-05-07	7.9
17	2	1586	208	23	VIG	2003-04-29	8.1
95	1	85	208	2	qwrqwr	2017-12-01	9.3
83	2	528	173	4	lepton	2006-09-29	8.5
18	1	1572	173	7	ZrenBy	2003-09-01	7.6
70	1	657	169	3	Serge I	2009-04-17	7.9
9	2	1330	168	30	vasia armor	2010-05-21	7.9
108	1	493	155	0	mslava	2003-12-23	7.3
94	2	247	153	0	pickman	2011-04-27	8.3
303	2	11	153	0	MikhailYakovlev535	2020-06-23	6.3
112	1	30	149	2	Gosha	2020-06-03	9.0
30	1	1700	138	3	Serge I	2003-08-28	7.9
81	2	587	136	12	$erges	2008-05-10	8.3
56	1	1013	126	3	Fiolent	2004-06-22	7.9
52	1	457	125	3	Serge I	2015-01-10	8.6
36	3	985	122	21	risp	2011-05-06	8.0
16	2	844	116	60	qwrqwr	2014-07-18	7.4
42	1	1576	110	14	Serge I	2003-06-05	7.6
21	1	1148	105	9	paparome	2006-03-14	8.0
13	1	1666	99	21	ZrenBy	2003-09-01	7.5
39	2	1334	98	21	Serge I	2003-08-28	7.5
53	1	1426	98	25	DimaN	2004-03-01	7.6
57	1	88	94	12	Kursist	2020-10-10	8.7
28	1	1158	94	11	ZrenBy	2003-09-01	7.5
14	1	2386	88	36	Serge I	2003-04-08	7.5
24	2	1567	86	6	Aaz	2004-02-26	6.9
29	2	1024	82	40	GiBis	2011-09-17	7.5
31	1	990	64	7	Fiolent	2004-06-22	7.8
7	1	28	62	7	Baser	2021-02-27	9.3
117	1	426	57	0	Fiolent	2003-12-26	7.6
8	2	1408	50	93	Serge I	2008-06-21	7.6
48	1	1115	43	6	Serge I	2009-06-22	7.4
11	1	1841	42	15	ZrenBy	2003-09-01	7.5
22	1	1564	40	12	ZrenBy	2003-09-01	7.3
27	1	1224	36	8	Fiolent	2004-02-26	7.3
235	2	4	35	0	Kursist	2021-07-10	9.0
10	1	657	25	46	Serge I	2017-01-20	8.0
15	1	1148	24	8	Dmitrij Grinkevich	2012-04-21	7.5
306	1	10	15	0	Baser	2021-02-26	9.3
301	0	43	7	0	pegoopik	2012-03-23	8.9
236	1	2		0	Baser	2021-07-24	8.0

Home
Week news

Certification

SQL exercises

HELP

Performance

Profile
References

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