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

SQL exercises

November 27, 17:56 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

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	13	157657	0	Baser	2016-11-12	9.9
217	4	9	113664	4	pegoopik	2015-08-28	9.2
234	3	5	95156	1	Kursist	2020-02-28	9.7
151	3	35	90967	4	anddros	2008-12-30	9.0
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	1	pegoopik	2011-04-28	8.5
190	4	17	70717	1	vlksm	2012-03-17	8.9
255	4	14	68481	3	vlksm	2012-02-14	9.8
252	2	34	67434	3	Ozzy	2009-06-14	8.3
101	4	218	66697	17	pegoopik	2010-11-20	9.4
178	3	23	64295	1	Baser	2011-08-13	9.1
102	4	184	64195	8	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
220	3	7	58774	1	pegoopik	2016-12-17	10.0
96	3	416	58462	81	anddros	2008-11-22	8.8
191	3	14	58423	0	qwrqwr	2012-06-08	9.5
143	5	46	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	26	47200	0	=Maxim=	2011-12-31	8.8
169	3	31	45744	0	Valdaj	2010-09-02	8.5
138	5	146	44372	33	Cyrilus	2005-12-09	9.1
93	3	170	42786	5	qwrqwr	2014-03-14	9.3
173	1	52	40030	3	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	106	37589	2	pegoopik	2014-02-14	9.0
99	3	199	35317	8	Dmitrij Grinkevich	2012-05-05	8.3
188	3	17	34385	1	qwrqwr	2012-02-04	9.8
148	2	66	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	560	27545	9	paparome	2006-07-26	8.5
49	2	1193	26758	23	anddros	2009-06-05	7.9
163	3	19	26664	0	Ozzy	2010-01-08	9.6
57	2	156	26004	16	Kursist	2020-10-10	8.3
224	3	11	24375	0	selber	2017-04-14	9.5
160	3	27	24342	0	Ozzy	2009-08-07	9.6
154	4	26	23397	3	anddros	2009-03-18	9.9
186	1	37	23340	0	Ozzy	2011-12-30	9.2
149	3	35	21580	2	$erges	2008-09-08	9.2
161	3	22	21439	3	Ozzy	2009-11-06	9.3
119	5	109	20891	4	Velmont	2014-03-07	9.6
153	3	37	20110	4	Ozzy	2009-02-14	9.5
116	5	248	19494	20	$erges	2008-12-13	9.4
126	2	186	18693	12	$erges	2008-09-07	8.6
150	4	37	18162	4	@Nikotin	2008-11-09	8.6
147	4	27	18075	3	$erges	2010-08-06	9.7
171	3	19	17760	1	Ozzy	2010-12-05	9.3
122	1	138	16023	2	Dmitrij Grinkevich	2012-09-14	5.9
237	3	2	15761	2	Baser	2022-05-13	10.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	2007	13539	23	Serge I	2004-06-23	7.5
145	3	71	11864	1	pvv	2008-01-07	8.6
62	2	723	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	284	10702	6	vlksm	2008-11-27	8.8
100	4	253	10440	10	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
183	2	30	9016	2	GriGrim	2011-11-12	9.1
210	2	15	9016	0	_dimon_	2014-02-07	10.0
257	4	17	8812	1	pegoopik	2012-02-20	9.4
230	2	8	8606	1	pegoopik	2018-07-27	9.8
208	3	14	8424	0	pegoopik	2013-12-20	8.8
218	4	13	8380	2	al29	2016-04-04	9.6
115	2	82	8174	1	selber	2016-05-28	9.1
139	2	126	7537	2	Snowbear	2006-09-09	8.3
155	3	27	7331	2	vlksm	2009-04-17	9.9
225	2	11	6846	0	pegoopik	2017-07-15	9.9
200	3	19	6776	0	qwrqwr	2013-10-05	9.3
144	4	46	6638	4	pvv	2008-01-01	7.3
141	4	80	6558	10	vlksm	2006-10-29	9.0
137	4	191	6428	25	Cyrilus	2005-03-06	9.2
222	2	14	6419	1	pegoopik	2016-12-23	9.8
152	3	47	6401	4	vlksm	2009-01-05	9.7
180	3	32	6342	0	qwrqwr	2011-09-16	9.6
77	2	309	6212	32	selber	2015-07-10	8.7
198	2	23	5228	0	Angellore	2013-09-13	9.4
179	3	17	4926	0	pegoopik	2011-09-17	9.2
123	3	248	4724	38	Ozzy	2009-08-22	9.0
45	2	456	4707	16	dumkan	2016-04-03	8.0
229	3	7	4615	1	al29	2018-03-23	9.7
227	3	10	4590	1	mcrain	2017-12-08	7.3
140	2	82	4518	2	_Bkmz_	2010-01-30	8.9
168	2	43	4507	2	qwrqwr	2010-08-27	9.5
213	2	26	4445	0	qwrqwr	2014-10-17	9.6
121	3	409	4424	3	ZrenBy	2004-02-26	7.7
133	2	91	4324	0	pickman	2011-07-01	8.2
132	3	110	4322	4	risp	2010-01-25	7.7
231	3	6	4196	0	mcrain	2018-08-24	10.0
26	1	1492	3993	25	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
135	3	65	3181	1	qwrqwr	2013-04-19	8.9
65	3	719	3058	48	Ozzy	2010-01-29	7.7
131	2	92	2994	1	GriGrim	2012-05-25	8.6
233	1	15	2920	2	pegoopik	2019-03-08	10.0
72	4	1023	2891	149	paparome	2005-12-03	9.2
107	2	407	2864	9	Fiolent	2004-02-26	8.1
167	3	24	2850	0	qwrqwr	2011-01-18	9.9
98	4	586	2770	44	ZrenBy	2003-09-01	8.2
221	2	17	2706	1	Baser	2016-11-05	8.9
87	4	638	2653	89	Roman Golubin	2006-07-14	9.3
207	3	17	2644	0	pegoopik	2016-01-15	10.0
232	3	6	2570	0	al29	2018-08-20	10.0
256	1	39	2460	1	anddros	2013-11-08	8.9
89	3	416	2414	31	_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	114	2306	5	Ozzy	2011-05-12	7.5
146	3	62	2262	3	paparome	2008-01-22	9.7
209	1	33	2078	1	Baser	2013-12-30	8.0
199	3	20	1981	0	Baser	2013-08-17	8.4
228	1	19	1891	1	qwrqwr	2018-01-12	10.0
204	1	34	1878	1	anddros	2013-11-19	8.7
166	1	61	1865	1	anddros	2010-07-26	9.5
219	2	17	1856	0	pegoopik	2016-04-08	9.9
195	3	26	1775	0	Dmitrij Grinkevich	2013-04-20	9.1
71	3	544	1700	23	anddros	2009-12-26	8.4
76	3	456	1637	16	silver	2010-01-23	8.8
196	3	25	1616	0	qwrqwr	2013-05-17	9.4
125	3	374	1609	3	dimzv	2004-02-29	8.7
58	3	630	1540	12	qwrqwr	2013-03-01	8.2
235	2	7	1473	0	Kursist	2021-07-10	9.5
127	2	60	1441	2	GriGrim	2014-12-21	7.9
130	2	119	1434	0	anddros	2010-05-22	8.9
85	3	368	1434	19	Ozzy	2009-10-10	8.5
20	2	1506	1412	31	VIG	2003-09-01	8.0
142	2	115	1377	1	paparome	2007-03-24	9.0
84	3	419	1308	16	Ozzy	2009-12-26	8.4
134	3	175	1242	4	pvv	2008-01-22	8.5
111	2	456	1232	3	Fiolent	2005-01-19	8.3
105	2	142	1206	0	Baser	2013-09-20	8.6
197	1	43	1185	0	pegoopik	2013-06-10	8.8
64	3	608	1169	49	qwrqwr	2010-05-13	8.1
162	2	59	1167	0	Ozzy	2009-12-26	9.3
108	3	282	1166	5	crescent	2011-03-23	8.9
110	3	434	1166	11	Snowbear	2006-03-14	8.9
203	1	40	1137	1	=Maxim=	2013-10-05	9.4
226	3	10	1120	2	pegoopik	2017-10-14	9.3
307	2	19	1120	0	Baser	2017-06-29	8.5
80	2	343	1098	10	qwrqwr	2011-10-21	8.9
177	1	53	1004	0	pegoopik	2011-07-17	8.5
170	2	55	982	1	qwrqwr	2010-10-24	9.0
124	2	380	970	3	DimaN	2004-02-26	8.3
66	3	674	954	54	anddros	2009-12-26	8.5
32	1	1376	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	454	901	4	Serge I	2003-12-24	8.4
40	1	312	899	10	Serge I	2018-09-07	7.0
201	2	38	806	0	Baser	2013-09-21	8.7
129	2	274	769	7	DimaN	2004-03-01	7.5
305	1	25	732	0	Baser	2017-01-06	9.0
23	3	1565	690	124	Palkin	2007-03-29	8.4
43	2	538	689	5	qwrqwr	2015-04-24	8.4
91	2	227	672	1	smog	2012-05-26	9.1
192	2	48	608	0	Baser	2012-03-03	9.2
103	1	143	599	1	Baser	2013-10-05	7.4
82	3	390	590	11	_Virt_	2010-04-27	8.2
118	2	429	560	2	Fiolent	2004-01-05	8.2
75	2	401	559	4	qwrqwr	2011-07-22	7.5
67	2	584	556	18	Ozzy	2010-04-27	8.3
68	3	296	537	24	pegoopik	2014-08-01	8.2
47	3	963	518	14	qwrqwr	2010-11-20	8.1
60	3	2075	515	119	Serge I	2005-03-05	7.8
54	2	1352	507	45	Ozzy	2008-09-06	8.2
37	3	776	500	25	qwrqwr	2013-02-22	8.0
41	3	1132	488	18	qwrqwr	2010-04-26	8.1
79	1	969	485	14	Serge I	2003-06-05	7.7
69	2	176	462	7	Gosha	2017-12-15	9.1
35	3	589	421	13	Baser	2015-09-18	8.7
262	2	12	405	0	selber	2019-06-21	6.5
86	2	351	390	0	Ozzy	2010-03-05	8.6
109	2	496	385	1	VIG	2003-12-23	8.0
78	2	420	358	4	_ORA_	2010-04-27	7.5
51	1	571	358	15	Fiolent	2004-06-23	8.2
59	2	927	327	6	VIG	2003-12-22	8.3
63	1	1346	324	5	VIG	2003-06-05	7.6
73	1	462	322	3	Ruslan1707	2010-11-02	7.5
38	2	1045	319	25	ZrenBy	2003-09-01	7.5
34	2	1186	316	28	qwrqwr	2010-09-24	7.9
90	1	239	316	1	Dmitrij Grinkevich	2012-03-03	7.9
44	2	749	289	8	Serge I	2011-11-25	7.9
61	2	977	286	5	risp	2009-12-26	8.5
12	1	426	280	48	Serge I	2019-04-12	7.2
25	2	1242	275	29	DimaN	2004-06-22	7.1
97	1	372	271	3	dimzv	2004-03-01	7.7
74	2	671	268	9	vlksm	2008-06-21	8.3
46	2	1207	257	126	Serge I	2009-08-12	6.8
236	1	10	253	0	Baser	2021-07-24	9.6
104	1	143	247	0	pegoopik	2013-07-19	8.4
113	1	138	227	0	smog	2013-03-29	8.5
33	2	1270	225	27	DimaN	2004-03-01	7.6
128	1	229	224	4	inkerman	2007-09-14	8.4
55	2	573	219	6	VIG	2005-06-26	7.7
6	2	2056	212	88	Serge I	2005-05-07	8.0
17	2	1662	208	24	VIG	2003-04-29	8.1
95	1	98	208	2	qwrqwr	2017-12-01	9.4
83	2	538	173	5	lepton	2006-09-29	8.5
18	1	1643	173	9	ZrenBy	2003-09-01	7.7
70	1	677	169	3	Serge I	2009-04-17	7.9
9	2	1417	168	31	vasia armor	2010-05-21	8.0
50	1	540	155	11	mslava	2003-12-23	7.2
94	2	258	153	0	pickman	2011-04-27	8.3
303	2	11	153	1	MikhailYakovlev535	2020-06-23	6.3
30	1	1764	138	3	Serge I	2003-08-28	7.9
81	2	598	136	12	$erges	2008-05-10	8.3
112	1	42	131	2	Gosha	2020-06-03	9.0
56	1	1064	126	3	Fiolent	2004-06-22	8.0
52	1	511	125	3	Serge I	2015-01-10	8.6
36	3	1043	122	22	risp	2011-05-06	8.0
16	2	921	116	60	qwrqwr	2014-07-18	7.5
42	1	1629	110	14	Serge I	2003-06-05	7.7
21	1	1218	105	9	paparome	2006-03-14	8.1
13	1	1744	99	21	ZrenBy	2003-09-01	7.5
39	2	1389	98	24	Serge I	2003-08-28	7.5
53	1	1476	98	25	DimaN	2004-03-01	7.6
28	1	1224	94	10	ZrenBy	2003-09-01	7.5
14	1	2463	88	37	Serge I	2003-04-08	7.5
24	2	1632	86	6	Aaz	2004-02-26	7.0
29	2	1089	82	40	GiBis	2011-09-17	7.6
31	1	1058	64	6	Fiolent	2004-06-22	7.9
306	1	7	64	0	Baser	2022-04-29	7.4
117	1	432	57	0	Fiolent	2003-12-26	7.6
8	2	1506	50	93	Serge I	2008-06-21	7.6
7	1	207	45	78	Baser	2021-02-27	8.1
238	2	4	44	0	Baser	2022-05-13	8.0
48	1	1169	43	6	Serge I	2009-06-22	7.4
11	1	1922	42	15	ZrenBy	2003-09-01	7.5
22	1	1632	40	12	ZrenBy	2003-09-01	7.3
27	1	1289	36	8	Fiolent	2004-02-26	7.3
10	1	749	25	49	Serge I	2017-01-20	8.0
15	1	1226	24	8	Dmitrij Grinkevich	2012-04-21	7.6
88	2	30	15	1	Serge I	2021-10-15	9.0
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-2022. All rights reserved.
contact