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

SQL exercises

November 21, 12:06 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
  • Data simulation (DML);
  • Visual simulation (painting)
  • Exercises voting (SELECT)
  • Exercises voting (DML)

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

Certification

  • About 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
226	3	11	366927	1	pegoopik	2017-10-14	9.3
237	3	3	239814	1	Baser	2022-05-13	9.5
254	1	45	190491	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	37	90967	4	anddros	2008-12-30	8.9
159	3	17	88573	1	anddros	2012-07-22	8.2
190	4	17	74530	1	vlksm	2012-03-17	8.9
214	4	11	73899	0	pegoopik	2015-05-30	10.0
251	4	68	70257	3	paparome	2006-10-01	8.0
255	4	14	68481	4	vlksm	2012-02-14	9.8
252	2	35	67434	3	Ozzy	2009-06-14	8.4
178	3	23	67318	1	Baser	2011-08-13	9.1
101	4	226	66513	19	pegoopik	2010-11-20	9.3
40	1	366	64581	10	Serge I	2018-09-07	7.0
102	4	192	64201	8	GriGrim	2011-07-16	9.5
143	5	47	59698	14	inkerman	2007-10-07	8.8
172	3	22	59687	0	Ozzy	2011-03-11	9.8
304	2	25	58879	0	aks_nsk	2016-02-05	9.4
220	3	7	58774	1	pegoopik	2016-12-17	10.0
96	3	428	58455	81	anddros	2008-11-22	8.8
191	3	14	58423	0	qwrqwr	2012-06-08	9.5
175	3	30	58250	1	pegoopik	2011-04-28	8.5
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
187	3	26	49596	0	=Maxim=	2011-12-31	8.8
216	3	11	49497	1	pegoopik	2015-05-15	9.9
148	2	68	49300	7	vlksm	2008-09-06	9.3
258	3	25	46006	0	Baser	2014-09-19	7.6
138	5	148	44295	35	Cyrilus	2005-12-09	9.2
93	3	182	42869	5	qwrqwr	2014-03-14	9.3
253	3	30	39967	8	$erges	2008-05-17	8.9
173	1	52	39895	3	Ozzy	2011-01-13	9.3
120	4	112	39776	2	pegoopik	2014-02-14	9.0
165	2	31	38796	3	vlksm	2010-03-18	9.8
205	2	16	38349	0	qwrqwr	2013-11-22	8.9
194	4	15	37950	2	pegoopik	2012-07-13	10.0
261	1	35	37826	1	Fomichev	2013-12-07	7.0
188	3	17	34385	1	qwrqwr	2012-02-04	9.8
99	3	209	33463	9	Dmitrij Grinkevich	2012-05-05	8.2
152	3	49	32145	4	vlksm	2009-01-05	9.6
174	1	56	29935	0	qwrqwr	2011-02-25	9.3
219	2	17	29828	0	pegoopik	2016-04-08	9.9
212	3	16	28385	0	Baser	2014-10-14	8.9
157	3	24	28226	3	anddros	2009-06-05	9.6
92	2	572	27534	9	paparome	2006-07-26	8.5
49	2	1236	26757	23	anddros	2009-06-05	7.9
163	3	19	26664	0	Ozzy	2010-01-08	9.6
233	1	17	24576	0	pegoopik	2019-03-08	10.0
224	3	11	24375	0	selber	2017-04-14	9.5
160	3	27	24342	0	Ozzy	2009-08-07	9.6
57	2	209	23844	15	Kursist	2020-10-10	8.4
154	4	27	23397	4	anddros	2009-03-18	9.9
186	1	37	23332	0	Ozzy	2011-12-30	9.2
119	5	115	21998	4	Velmont	2014-03-07	9.6
149	3	36	21580	3	$erges	2008-09-08	9.3
153	3	39	21549	4	Ozzy	2009-02-14	9.3
161	3	22	21439	3	Ozzy	2009-11-06	9.3
116	5	253	19323	21	$erges	2008-12-13	9.4
126	2	191	18699	12	$erges	2008-09-07	8.6
150	4	38	18162	6	@Nikotin	2008-11-09	8.6
147	4	29	18075	2	$erges	2010-08-06	9.7
171	3	19	17760	1	Ozzy	2010-12-05	9.3
176	3	31	16018	0	qwrqwr	2011-05-20	9.5
200	3	19	15209	0	qwrqwr	2013-10-05	9.3
184	2	26	15179	1	Baser	2011-11-26	8.9
156	2	52	15162	3	anddros	2009-04-17	9.1
122	1	142	15140	2	Dmitrij Grinkevich	2012-09-14	5.8
146	3	63	14934	3	paparome	2008-01-22	9.7
19	1	2068	13538	23	Serge I	2004-06-23	7.5
145	3	72	11710	1	pvv	2008-01-07	8.7
164	2	37	11673	2	anddros	2010-04-26	9.7
193	2	22	11363	0	Baser	2012-07-06	8.3
62	2	763	10980	11	Dmitrij Grinkevich	2012-02-11	8.1
106	3	293	10696	5	vlksm	2008-11-27	8.8
100	4	263	10437	9	qwrqwr	2010-04-27	9.4
215	2	23	10161	0	pegoopik	2015-03-06	9.3
168	2	43	9629	2	qwrqwr	2010-08-27	9.5
206	4	14	9282	0	Baser	2013-11-23	9.1
210	2	15	9016	0	_dimon_	2014-02-07	10.0
183	2	30	9005	2	GriGrim	2011-11-12	9.1
257	4	17	8812	1	pegoopik	2012-02-20	9.4
230	2	8	8606	1	pegoopik	2018-07-27	9.8
218	4	13	8380	2	al29	2016-04-04	9.6
115	2	89	7699	1	selber	2016-05-28	8.9
139	2	128	7537	2	Snowbear	2006-09-09	8.3
155	3	28	7331	2	vlksm	2009-04-17	9.9
225	2	11	6846	0	pegoopik	2017-07-15	9.9
144	4	47	6638	4	pvv	2008-01-01	7.4
222	2	15	6419	0	pegoopik	2016-12-23	9.8
137	4	197	6301	25	Cyrilus	2005-03-06	9.2
141	4	81	6285	11	vlksm	2006-10-29	9.0
77	2	327	6213	32	selber	2015-07-10	8.7
262	2	14	5553	1	selber	2019-06-21	7.0
221	2	17	5048	1	Baser	2016-11-05	8.9
179	3	17	4926	0	pegoopik	2011-09-17	9.2
198	2	23	4815	1	Angellore	2013-09-13	9.4
45	2	504	4709	15	dumkan	2016-04-03	8.1
123	3	253	4682	38	Ozzy	2009-08-22	9.0
229	3	7	4615	1	al29	2018-03-23	9.7
227	3	10	4590	1	mcrain	2017-12-08	7.3
180	3	32	4579	0	qwrqwr	2011-09-16	9.6
208	3	14	4572	0	pegoopik	2013-12-20	8.8
213	2	26	4508	0	qwrqwr	2014-10-17	9.6
182	3	23	4468	0	Baser	2011-10-29	8.1
140	2	83	4465	2	_Bkmz_	2010-01-30	8.9
133	2	97	4315	0	pickman	2011-07-01	8.3
132	3	116	4274	4	risp	2010-01-25	7.5
121	3	414	4274	4	ZrenBy	2004-02-26	7.6
231	3	6	4196	0	mcrain	2018-08-24	10.0
26	1	1546	3980	28	VIG	2003-12-22	7.7
127	2	66	3702	2	GriGrim	2014-12-21	8.1
158	3	38	3421	0	Ozzy	2010-04-09	8.9
135	3	71	3206	2	qwrqwr	2013-04-19	9.1
65	3	746	3041	51	Ozzy	2010-01-29	7.7
72	4	1038	2940	151	paparome	2005-12-03	9.2
131	2	98	2931	1	GriGrim	2012-05-25	8.6
107	2	415	2864	10	Fiolent	2004-02-26	8.0
167	3	24	2850	0	qwrqwr	2011-01-18	9.9
185	1	44	2715	3	=Maxim=	2011-11-25	7.9
87	4	651	2696	89	Roman Golubin	2006-07-14	9.3
232	3	6	2570	0	al29	2018-08-20	10.0
98	4	598	2563	44	ZrenBy	2003-09-01	8.2
207	3	17	2464	0	pegoopik	2016-01-15	10.0
89	3	428	2412	31	_Bkmz_	2008-06-21	7.9
136	3	120	2361	5	Ozzy	2011-05-12	7.5
302	0	38	2325	0	pegoopik	2012-07-27	7.8
256	1	40	2312	1	anddros	2013-11-08	9.0
228	1	19	2312	1	qwrqwr	2018-01-12	10.0
169	3	32	2190	0	Valdaj	2010-09-02	8.5
196	3	25	2131	0	qwrqwr	2013-05-17	9.4
162	2	59	2035	1	Ozzy	2009-12-26	9.3
209	1	33	2003	1	Baser	2013-12-30	8.0
199	3	20	1940	0	Baser	2013-08-17	8.4
204	1	35	1874	1	anddros	2013-11-19	8.5
32	3	82	1852	18	blr_Oliver	2023-07-08	9.2
195	3	27	1760	0	Dmitrij Grinkevich	2013-04-20	9.1
76	3	475	1674	14	silver	2010-01-23	8.8
71	3	563	1662	24	anddros	2009-12-26	8.4
125	3	379	1609	3	dimzv	2004-02-29	8.7
166	1	63	1593	1	anddros	2010-07-26	9.6
58	3	672	1540	13	qwrqwr	2013-03-01	8.2
130	2	125	1427	0	anddros	2010-05-22	8.9
142	2	117	1422	1	paparome	2007-03-24	9.0
20	2	1566	1414	33	VIG	2003-09-01	8.0
85	3	382	1374	20	Ozzy	2009-10-10	8.5
84	3	433	1333	17	Ozzy	2009-12-26	8.3
134	3	181	1251	4	pvv	2008-01-22	8.6
202	2	29	1240	1	qwrqwr	2013-11-01	9.1
111	2	463	1226	3	Fiolent	2005-01-19	8.3
197	1	44	1199	0	pegoopik	2013-06-10	8.9
108	3	289	1168	5	crescent	2011-03-23	8.9
110	3	441	1164	12	Snowbear	2006-03-14	8.9
64	3	641	1162	50	qwrqwr	2010-05-13	8.1
105	2	150	1137	0	Baser	2013-09-20	8.6
203	1	42	1134	1	=Maxim=	2013-10-05	9.4
235	2	8	1124	0	Kursist	2021-07-10	9.6
307	2	19	1032	0	Baser	2017-06-29	8.5
80	2	359	1029	11	qwrqwr	2011-10-21	9.0
177	1	53	998	0	pegoopik	2011-07-17	8.5
170	2	56	985	1	qwrqwr	2010-10-24	9.1
66	3	700	984	54	anddros	2009-12-26	8.5
124	2	385	970	3	DimaN	2004-02-26	8.2
114	1	461	901	4	Serge I	2003-12-24	8.5
260	2	53	888	0	qwrqwr	2012-02-03	7.7
201	2	39	807	0	Baser	2013-09-21	8.8
129	2	280	773	7	DimaN	2004-03-01	7.5
43	2	582	689	3	qwrqwr	2015-04-24	8.4
23	3	1623	687	125	Palkin	2007-03-29	8.4
305	1	26	684	1	Baser	2017-01-06	9.1
91	2	239	671	1	smog	2012-05-26	9.1
192	2	49	610	0	Baser	2012-03-03	9.2
103	1	151	594	1	Baser	2013-10-05	7.5
82	3	404	572	12	_Virt_	2010-04-27	8.2
118	2	435	565	1	Fiolent	2004-01-05	8.1
75	2	418	558	4	qwrqwr	2011-07-22	7.5
67	2	610	557	18	Ozzy	2010-04-27	8.3
47	3	1007	517	14	qwrqwr	2010-11-20	8.2
54	2	1396	503	45	Ozzy	2008-09-06	8.2
41	3	1175	487	18	qwrqwr	2010-04-26	8.1
68	3	320	483	26	pegoopik	2014-08-01	8.1
79	1	986	483	14	Serge I	2003-06-05	7.8
60	3	2115	462	119	Serge I	2005-03-05	7.9
69	2	198	454	8	Gosha	2017-12-15	9.0
35	3	641	421	13	Baser	2015-09-18	8.7
37	3	822	421	25	qwrqwr	2013-02-22	8.0
86	2	364	396	0	Ozzy	2010-03-05	8.6
109	2	504	385	1	VIG	2003-12-23	8.0
51	1	616	361	14	Fiolent	2004-06-23	8.3
78	2	436	358	5	_ORA_	2010-04-27	7.5
59	2	968	323	7	VIG	2003-12-22	8.3
63	1	1386	320	5	VIG	2003-06-05	7.6
73	1	478	318	3	Ruslan1707	2010-11-02	7.5
38	2	1090	315	26	ZrenBy	2003-09-01	7.5
34	2	1238	305	26	qwrqwr	2010-09-24	7.9
90	1	251	305	1	Dmitrij Grinkevich	2012-03-03	8.0
44	2	793	289	8	Serge I	2011-11-25	7.9
61	2	1018	282	5	risp	2009-12-26	8.5
97	1	384	279	3	dimzv	2004-03-01	7.6
25	2	1300	275	31	DimaN	2004-06-22	7.2
12	1	516	269	47	Serge I	2019-04-12	7.0
74	2	688	265	8	vlksm	2008-06-21	8.3
104	1	151	251	0	pegoopik	2013-07-19	8.4
46	2	1251	249	127	Serge I	2009-08-12	6.9
33	2	1320	227	26	DimaN	2004-03-01	7.7
128	1	235	225	4	inkerman	2007-09-14	8.4
113	1	145	218	0	smog	2013-03-29	8.6
55	2	621	216	6	VIG	2005-06-26	7.8
6	2	2204	211	127	Serge I	2005-05-07	8.0
17	2	1726	208	27	VIG	2003-04-29	8.2
5	1	168	205	136	Serge I	2023-06-18	8.6
236	1	12	198	0	Baser	2021-07-24	9.7
95	1	111	196	2	qwrqwr	2017-12-01	9.4
29	2	1143	194	40	GiBis	2011-09-17	7.5
83	2	553	177	5	lepton	2006-09-29	8.6
18	1	1705	168	12	ZrenBy	2003-09-01	7.7
9	2	1506	165	31	vasia armor	2010-05-21	8.0
70	1	698	164	3	Serge I	2009-04-17	7.9
50	1	599	156	17	mslava	2003-12-23	7.2
94	2	270	150	0	pickman	2011-04-27	8.3
30	1	1817	138	3	Serge I	2003-08-28	7.9
81	2	614	135	12	$erges	2008-05-10	8.3
56	1	1107	129	3	Fiolent	2004-06-22	8.0
52	1	555	123	3	Serge I	2015-01-10	8.6
36	3	1091	123	23	risp	2011-05-06	8.0
16	2	991	116	60	qwrqwr	2014-07-18	7.5
112	1	54	115	2	Gosha	2020-06-03	8.7
42	1	1670	107	15	Serge I	2003-06-05	7.7
21	1	1277	106	9	paparome	2006-03-14	8.0
39	2	1433	103	24	Serge I	2003-08-28	7.5
13	1	1819	98	22	ZrenBy	2003-09-01	7.6
53	1	1520	97	25	DimaN	2004-03-01	7.7
303	2	9	97	0	selber	2023-12-27	9.0
238	2	6	93	0	Baser	2022-05-13	8.3
28	1	1277	92	10	ZrenBy	2003-09-01	7.6
14	1	2532	89	38	Serge I	2003-04-08	7.6
24	2	1692	86	6	Aaz	2004-02-26	7.0
31	1	1110	64	6	Fiolent	2004-06-22	7.9
117	1	438	58	0	Fiolent	2003-12-26	7.7
306	1	14	46	1	Baser	2022-04-29	8.3
7	1	340	42	108	Baser	2021-02-27	8.0
8	2	1602	42	94	Serge I	2008-06-21	7.7
22	1	1691	42	12	ZrenBy	2003-09-01	7.4
11	1	2006	41	15	ZrenBy	2003-09-01	7.6
48	1	1213	41	6	Serge I	2009-06-22	7.4
27	1	1342	36	8	Fiolent	2004-02-26	7.4
10	1	840	23	49	Serge I	2017-01-20	8.1
15	1	1297	23	8	Dmitrij Grinkevich	2012-04-21	7.6
88	2	53	14	1	Serge I	2021-10-15	9.2
301	0	45	7	0	pegoopik	2012-03-23	8.7

Home
Week news

Certification

SQL exercises

HELP

Performance

Profile
References

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