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

SQL exercises

November 25, 19:16 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

Создание сайта с нуля
Создание сайтов любой сложности. Индивидуальный подход! Эксклюзивный дизайн
it-akita.com
Морской контейнер 40 футов купить в Москве
Контейнер для оборудования
containerr.ru
Ссылка на гидру
ссылка на гидру
runetaba.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	201683	1	Baser	2011-09-02	8.8
211	2	13	187896	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
214	4	11	73899	0	pegoopik	2015-05-30	10.0
175	3	29	71452	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
251	4	68	70189	3	paparome	2006-10-01	8.0
255	4	14	68481	3	vlksm	2012-02-14	9.8
101	4	204	66645	16	pegoopik	2010-11-20	9.4
102	4	171	64152	7	GriGrim	2011-07-16	9.4
252	2	34	63484	3	Ozzy	2009-06-14	8.3
178	3	22	63420	1	Baser	2011-08-13	9.1
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	401	61496	81	anddros	2008-11-22	8.8
191	3	14	58423	0	qwrqwr	2012-06-08	9.5
143	5	44	54551	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	49210	0	=Maxim=	2011-12-31	8.8
169	3	29	45715	0	Valdaj	2010-09-02	8.4
93	3	154	45443	5	qwrqwr	2014-03-14	9.3
138	5	144	44293	33	Cyrilus	2005-12-09	9.2
205	2	15	40832	0	qwrqwr	2013-11-22	8.9
120	4	93	39861	1	pegoopik	2014-02-14	8.9
165	2	30	38636	3	vlksm	2010-03-18	9.9
194	4	15	37950	1	pegoopik	2012-07-13	10.0
261	1	35	37829	1	Fomichev	2013-12-07	7.0
253	3	30	36920	7	$erges	2008-05-17	8.9
99	3	184	35295	8	Dmitrij Grinkevich	2012-05-05	8.1
188	3	17	34385	1	qwrqwr	2012-02-04	9.8
157	3	24	28226	2	anddros	2009-06-05	9.6
49	2	1117	28161	22	anddros	2009-06-05	7.9
212	3	16	27716	0	Baser	2014-10-14	8.9
92	2	544	27541	9	paparome	2006-07-26	8.5
224	3	10	26714	0	selber	2017-04-14	9.4
163	3	19	26664	0	Ozzy	2010-01-08	9.6
186	1	37	24559	0	Ozzy	2011-12-30	9.2
160	3	26	24221	0	Ozzy	2009-08-07	9.6
154	4	25	23397	3	anddros	2009-03-18	9.9
119	5	94	21673	5	Velmont	2014-03-07	9.7
149	3	33	21496	2	$erges	2008-09-08	9.2
161	3	21	20348	3	Ozzy	2009-11-06	9.2
173	1	52	18776	2	Ozzy	2011-01-13	9.3
126	2	179	18684	11	$erges	2008-09-07	8.6
171	3	19	17760	1	Ozzy	2010-12-05	9.3
150	4	36	17228	4	@Nikotin	2008-11-09	8.5
147	4	26	17024	2	$erges	2010-08-06	9.7
122	1	124	16020	2	Dmitrij Grinkevich	2012-09-14	5.9
156	2	51	15525	3	anddros	2009-04-17	9.1
184	2	25	15219	2	Baser	2011-11-26	8.8
176	3	31	14965	0	qwrqwr	2011-05-20	9.5
151	3	32	13744	5	anddros	2008-12-30	8.9
19	1	1916	13536	23	Serge I	2004-06-23	7.5
193	2	21	11860	0	Baser	2012-07-06	8.3
145	3	69	11844	1	pvv	2008-01-07	8.6
174	1	56	11817	0	qwrqwr	2011-02-25	9.3
148	2	65	11640	7	vlksm	2008-09-06	9.3
62	2	655	11566	9	Dmitrij Grinkevich	2012-02-11	8.0
106	3	272	10671	5	vlksm	2008-11-27	8.8
100	4	238	10332	10	qwrqwr	2010-04-27	9.4
164	2	37	10058	1	anddros	2010-04-26	9.7
210	2	14	9550	0	_dimon_	2014-02-07	10.0
206	4	14	9282	0	Baser	2013-11-23	9.1
218	4	12	8905	2	al29	2016-04-04	9.6
257	4	17	8812	1	pegoopik	2012-02-20	9.4
115	2	67	8675	1	selber	2016-05-28	9.2
225	2	9	8561	0	pegoopik	2017-07-15	9.8
208	3	14	8424	0	pegoopik	2013-12-20	8.8
139	2	124	7533	2	Snowbear	2006-09-09	8.3
183	2	30	7303	2	GriGrim	2011-11-12	9.1
155	3	26	6905	2	vlksm	2009-04-17	9.9
77	2	286	6577	31	selber	2015-07-10	8.7
137	4	189	6413	24	Cyrilus	2005-03-06	9.2
152	3	46	6388	4	vlksm	2009-01-05	9.7
230	2	7	6349	1	pegoopik	2018-07-27	9.8
180	3	32	6318	0	qwrqwr	2011-09-16	9.6
144	4	44	6306	4	pvv	2008-01-01	7.3
200	3	18	6257	0	qwrqwr	2013-10-05	9.3
153	3	35	6216	5	Ozzy	2009-02-14	9.5
141	4	78	6121	9	vlksm	2006-10-29	9.0
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	5416	0	Angellore	2013-09-13	9.4
227	3	9	5136	1	mcrain	2017-12-08	7.0
45	2	376	4995	16	dumkan	2016-04-03	8.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	233	4689	39	Ozzy	2009-08-22	9.0
116	5	233	4626	21	$erges	2008-12-13	9.3
140	2	80	4503	2	_Bkmz_	2010-01-30	8.9
121	3	395	4356	4	ZrenBy	2004-02-26	7.8
133	2	89	4315	0	pickman	2011-07-01	8.2
132	3	108	4298	4	risp	2010-01-25	7.6
213	2	26	4184	0	qwrqwr	2014-10-17	9.6
26	1	1408	3992	24	VIG	2003-12-22	7.7
168	2	42	3902	2	qwrqwr	2010-08-27	9.5
215	2	23	3868	0	pegoopik	2015-03-06	9.3
158	3	38	3282	0	Ozzy	2010-04-09	8.9
182	3	22	3230	0	Baser	2011-10-29	8.1
135	3	62	3171	1	qwrqwr	2013-04-19	8.9
232	3	5	3110	0	al29	2018-08-20	10.0
65	3	673	3027	46	Ozzy	2010-01-29	7.7
222	2	11	3016	1	pegoopik	2016-12-23	9.8
131	2	88	2989	1	GriGrim	2012-05-25	8.5
221	2	13	2858	0	Baser	2016-11-05	8.6
98	4	571	2819	44	ZrenBy	2003-09-01	8.2
107	2	395	2778	9	Fiolent	2004-02-26	8.1
72	4	997	2777	150	paparome	2005-12-03	9.2
167	3	24	2747	0	qwrqwr	2011-01-18	9.9
87	4	620	2641	90	Roman Golubin	2006-07-14	9.3
207	3	16	2639	0	pegoopik	2016-01-15	10.0
233	1	13	2509	1	pegoopik	2019-03-08	10.0
256	1	39	2460	1	anddros	2013-11-08	8.9
89	3	400	2425	29	_Bkmz_	2008-06-21	7.8
136	3	111	2289	5	Ozzy	2011-05-12	7.3
146	3	60	2281	3	paparome	2008-01-22	9.7
209	1	33	2198	1	Baser	2013-12-30	8.0
228	1	18	2194	1	qwrqwr	2018-01-12	10.0
302	0	37	2173	0	pegoopik	2012-07-27	7.6
219	2	15	2104	0	pegoopik	2016-04-08	9.9
199	3	20	2073	0	Baser	2013-08-17	8.4
204	1	34	1989	1	anddros	2013-11-19	8.7
166	1	59	1937	2	anddros	2010-07-26	9.6
195	3	26	1845	0	Dmitrij Grinkevich	2013-04-20	9.1
71	3	519	1785	20	anddros	2009-12-26	8.4
196	3	25	1658	0	qwrqwr	2013-05-17	9.4
125	3	359	1606	3	dimzv	2004-02-29	8.7
58	3	559	1540	10	qwrqwr	2013-03-01	8.1
127	2	55	1511	2	GriGrim	2014-12-21	7.7
130	2	115	1472	0	anddros	2010-05-22	8.8
76	3	431	1420	17	silver	2010-01-23	8.8
85	3	350	1414	17	Ozzy	2009-10-10	8.5
20	2	1411	1410	36	VIG	2003-09-01	8.0
142	2	113	1375	1	paparome	2007-03-24	9.0
185	1	43	1372	3	=Maxim=	2011-11-25	7.9
84	3	397	1305	18	Ozzy	2009-12-26	8.4
226	3	9	1236	2	pegoopik	2017-10-14	9.2
111	2	442	1229	3	Fiolent	2005-01-19	8.3
134	3	173	1222	4	pvv	2008-01-22	8.6
197	1	43	1194	0	pegoopik	2013-06-10	8.8
105	2	129	1193	0	Baser	2013-09-20	8.5
64	3	557	1167	47	qwrqwr	2010-05-13	7.9
307	2	19	1120	0	Baser	2017-06-29	8.5
88	3	267	1106	5	crescent	2011-03-23	8.9
110	3	421	1097	11	Snowbear	2006-03-14	8.8
203	1	40	1096	1	=Maxim=	2013-10-05	9.4
80	2	325	1095	10	qwrqwr	2011-10-21	8.9
162	2	59	1019	0	Ozzy	2009-12-26	9.3
66	3	632	1001	54	anddros	2009-12-26	8.4
177	1	53	982	0	pegoopik	2011-07-17	8.5
40	1	221	972	14	Serge I	2018-09-07	7.1
124	2	365	964	3	DimaN	2004-02-26	8.3
170	2	54	963	1	qwrqwr	2010-10-24	9.0
202	2	29	959	0	qwrqwr	2013-11-01	9.1
32	1	1286	919	7	Roman Golubin	2005-12-13	7.5
114	1	440	891	4	Serge I	2003-12-24	8.4
260	2	52	870	0	qwrqwr	2012-02-03	7.7
201	2	38	794	0	Baser	2013-09-21	8.7
129	2	270	767	7	DimaN	2004-03-01	7.5
305	1	25	732	0	Baser	2017-01-06	9.0
43	2	460	731	3	qwrqwr	2015-04-24	8.5
23	3	1477	691	121	Palkin	2007-03-29	8.4
91	2	211	669	2	smog	2012-05-26	9.1
103	1	130	595	1	Baser	2013-10-05	7.3
192	2	48	594	0	Baser	2012-03-03	9.2
82	3	369	580	14	_Virt_	2010-04-27	8.2
68	3	263	559	21	pegoopik	2014-08-01	8.0
118	2	415	551	1	Fiolent	2004-01-05	8.2
67	2	549	550	16	Ozzy	2010-04-27	8.3
75	2	378	545	4	qwrqwr	2011-07-22	7.4
60	3	2007	514	119	Serge I	2005-03-05	7.8
47	3	886	512	16	qwrqwr	2010-11-20	8.1
54	2	1279	506	45	Ozzy	2008-09-06	8.2
37	3	691	497	27	qwrqwr	2013-02-22	8.0
79	1	950	484	14	Serge I	2003-06-05	7.7
41	3	1057	481	17	qwrqwr	2010-04-26	8.1
69	2	141	449	7	Gosha	2017-12-15	8.9
35	3	501	445	11	Baser	2015-09-18	8.8
262	2	11	405	0	selber	2019-06-21	6.5
50	1	764	398	5	mslava	2003-12-22	8.3
109	2	483	380	1	VIG	2003-12-23	8.0
86	2	332	377	0	Ozzy	2010-03-05	8.6
78	2	400	357	3	_ORA_	2010-04-27	7.4
51	1	494	356	14	Fiolent	2004-06-23	8.1
63	1	1278	323	5	VIG	2003-06-05	7.6
59	2	855	322	6	VIG	2003-12-22	8.3
73	1	437	319	3	Ruslan1707	2010-11-02	7.4
34	2	1103	313	25	qwrqwr	2010-09-24	7.9
90	1	224	305	0	Dmitrij Grinkevich	2012-03-03	7.8
44	2	671	285	8	Serge I	2011-11-25	7.9
61	2	909	284	5	risp	2009-12-26	8.4
38	2	963	280	21	ZrenBy	2003-09-01	7.6
12	1	284	280	39	Serge I	2019-04-12	7.2
25	2	1155	274	29	DimaN	2004-06-22	7.0
97	1	356	269	3	dimzv	2004-03-01	7.7
74	2	647	266	8	vlksm	2008-06-21	8.3
46	2	1132	250	126	Serge I	2009-08-12	6.7
104	1	130	245	0	pegoopik	2013-07-19	8.4
33	2	1182	223	25	DimaN	2004-03-01	7.6
113	1	124	222	0	smog	2013-03-29	8.4
128	1	224	222	4	inkerman	2007-09-14	8.3
95	1	80	216	2	qwrqwr	2017-12-01	9.3
55	2	467	215	7	VIG	2005-06-26	7.7
6	2	1809	212	17	Serge I	2005-05-07	7.8
17	2	1559	208	22	VIG	2003-04-29	8.1
303	2	9	187	0	MikhailYakovlev535	2020-06-23	5.6
112	1	16	180	1	Gosha	2020-06-03	9.2
18	1	1551	173	6	ZrenBy	2003-09-01	7.6
83	2	518	172	4	lepton	2006-09-29	8.4
70	1	648	169	3	Serge I	2009-04-17	7.8
9	2	1294	166	27	vasia armor	2010-05-21	7.9
30	1	1677	138	3	Serge I	2003-08-28	7.9
81	2	580	138	12	$erges	2008-05-10	8.2
94	2	242	130	0	pickman	2011-04-27	8.2
52	1	433	128	3	Serge I	2015-01-10	8.6
108	1	487	127	0	mslava	2003-12-23	7.3
56	1	991	126	3	Fiolent	2004-06-22	7.9
16	2	816	115	61	qwrqwr	2014-07-18	7.4
36	3	963	113	20	risp	2011-05-06	8.0
42	1	1555	111	14	Serge I	2003-06-05	7.6
57	1	16	108	3	Kursist	2020-10-10	9.8
21	1	1123	104	9	paparome	2006-03-14	8.0
13	1	1638	98	21	ZrenBy	2003-09-01	7.5
53	1	1403	98	25	DimaN	2004-03-01	7.6
39	2	1314	97	21	Serge I	2003-08-28	7.5
28	1	1132	94	13	ZrenBy	2003-09-01	7.5
14	1	2360	88	36	Serge I	2003-04-08	7.5
29	2	1001	78	42	GiBis	2011-09-17	7.5
24	2	1546	77	6	Aaz	2004-02-26	6.9
31	1	964	63	7	Fiolent	2004-06-22	7.8
117	1	417	56	0	Fiolent	2003-12-26	7.5
8	2	1360	49	83	Serge I	2008-06-21	7.6
11	1	1809	41	15	ZrenBy	2003-09-01	7.5
48	1	1092	41	6	Serge I	2009-06-22	7.4
22	1	1541	38	12	ZrenBy	2003-09-01	7.2
27	1	1201	36	9	Fiolent	2004-02-26	7.3
7	1	2412	32	78	Serge I	2006-11-17	7.9
10	1	619	25	44	Serge I	2017-01-20	8.0
15	1	1122	22	8	Dmitrij Grinkevich	2012-04-21	7.5
301	0	43	7	0	pegoopik	2012-03-23	8.9

Home
Week news

Certification

SQL exercises

HELP

Performance

Profile
References

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