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

SQL exercises

October 30, 15:58 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	36	90967	5	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	224	66513	19	pegoopik	2010-11-20	9.3
40	1	364	64581	10	Serge I	2018-09-07	7.0
102	4	190	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	427	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	181	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	207	33463	9	Dmitrij Grinkevich	2012-05-05	8.2
152	3	48	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	571	27534	9	paparome	2006-07-26	8.5
49	2	1234	26757	22	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	205	23844	16	Kursist	2020-10-10	8.4
154	4	27	23397	3	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	38	21549	4	Ozzy	2009-02-14	9.3
161	3	22	21439	3	Ozzy	2009-11-06	9.3
116	5	253	19323	20	$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	2066	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	762	10980	10	Dmitrij Grinkevich	2012-02-11	8.0
106	3	291	10696	5	vlksm	2008-11-27	8.8
100	4	261	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	88	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	325	6213	33	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	502	4709	14	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	744	3041	51	Ozzy	2010-01-29	7.7
72	4	1036	2940	150	paparome	2005-12-03	9.2
131	2	98	2931	1	GriGrim	2012-05-25	8.6
107	2	414	2864	9	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	597	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	78	1852	17	blr_Oliver	2023-07-08	9.3
195	3	27	1760	0	Dmitrij Grinkevich	2013-04-20	9.1
76	3	473	1674	15	silver	2010-01-23	8.8
71	3	560	1662	25	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	669	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	1565	1414	32	VIG	2003-09-01	8.0
85	3	382	1374	19	Ozzy	2009-10-10	8.5
84	3	432	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	462	1226	3	Fiolent	2005-01-19	8.3
197	1	44	1199	0	pegoopik	2013-06-10	8.9
108	3	288	1168	5	crescent	2011-03-23	8.9
110	3	440	1164	12	Snowbear	2006-03-14	8.9
64	3	639	1162	50	qwrqwr	2010-05-13	8.1
105	2	148	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	358	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	697	984	54	anddros	2009-12-26	8.5
124	2	385	970	3	DimaN	2004-02-26	8.2
114	1	460	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	580	689	3	qwrqwr	2015-04-24	8.4
23	3	1622	687	125	Palkin	2007-03-29	8.4
305	1	26	684	1	Baser	2017-01-06	9.1
91	2	238	671	1	smog	2012-05-26	9.1
192	2	49	610	0	Baser	2012-03-03	9.2
103	1	149	594	1	Baser	2013-10-05	7.5
82	3	403	572	12	_Virt_	2010-04-27	8.2
118	2	435	565	1	Fiolent	2004-01-05	8.1
75	2	417	558	4	qwrqwr	2011-07-22	7.5
67	2	608	557	17	Ozzy	2010-04-27	8.3
47	3	1004	517	14	qwrqwr	2010-11-20	8.2
54	2	1394	503	45	Ozzy	2008-09-06	8.2
41	3	1174	487	18	qwrqwr	2010-04-26	8.1
68	3	318	483	26	pegoopik	2014-08-01	8.1
79	1	985	483	14	Serge I	2003-06-05	7.8
60	3	2113	462	119	Serge I	2005-03-05	7.9
69	2	196	454	8	Gosha	2017-12-15	9.0
35	3	638	421	13	Baser	2015-09-18	8.7
37	3	820	421	26	qwrqwr	2013-02-22	8.0
86	2	364	396	0	Ozzy	2010-03-05	8.6
109	2	503	385	1	VIG	2003-12-23	8.0
51	1	614	361	14	Fiolent	2004-06-23	8.3
78	2	435	358	5	_ORA_	2010-04-27	7.5
59	2	966	323	6	VIG	2003-12-22	8.3
63	1	1385	320	5	VIG	2003-06-05	7.6
73	1	477	318	3	Ruslan1707	2010-11-02	7.5
38	2	1089	315	25	ZrenBy	2003-09-01	7.5
34	2	1236	305	26	qwrqwr	2010-09-24	7.9
90	1	251	305	1	Dmitrij Grinkevich	2012-03-03	8.0
44	2	791	289	8	Serge I	2011-11-25	7.9
61	2	1016	282	5	risp	2009-12-26	8.5
97	1	383	279	3	dimzv	2004-03-01	7.6
25	2	1299	275	31	DimaN	2004-06-22	7.2
12	1	513	269	47	Serge I	2019-04-12	7.0
74	2	687	265	8	vlksm	2008-06-21	8.3
104	1	149	251	0	pegoopik	2013-07-19	8.4
46	2	1249	249	127	Serge I	2009-08-12	6.9
33	2	1319	227	26	DimaN	2004-03-01	7.7
128	1	235	225	4	inkerman	2007-09-14	8.4
113	1	144	218	0	smog	2013-03-29	8.6
55	2	619	216	6	VIG	2005-06-26	7.8
6	2	2203	211	127	Serge I	2005-05-07	8.0
17	2	1724	208	27	VIG	2003-04-29	8.2
5	1	161	205	128	Serge I	2023-06-18	8.7
236	1	12	198	0	Baser	2021-07-24	9.7
95	1	110	196	2	qwrqwr	2017-12-01	9.4
29	2	1142	194	40	GiBis	2011-09-17	7.5
83	2	552	177	5	lepton	2006-09-29	8.6
18	1	1703	168	12	ZrenBy	2003-09-01	7.7
9	2	1504	165	31	vasia armor	2010-05-21	8.0
70	1	696	164	3	Serge I	2009-04-17	7.9
50	1	596	156	17	mslava	2003-12-23	7.2
94	2	269	150	0	pickman	2011-04-27	8.3
30	1	1817	138	3	Serge I	2003-08-28	7.9
81	2	613	135	12	$erges	2008-05-10	8.3
56	1	1105	129	3	Fiolent	2004-06-22	8.0
52	1	553	123	3	Serge I	2015-01-10	8.6
36	3	1089	123	23	risp	2011-05-06	8.0
16	2	988	116	60	qwrqwr	2014-07-18	7.5
112	1	53	115	2	Gosha	2020-06-03	8.7
42	1	1668	107	15	Serge I	2003-06-05	7.7
21	1	1276	106	9	paparome	2006-03-14	8.0
39	2	1432	103	24	Serge I	2003-08-28	7.5
13	1	1818	98	22	ZrenBy	2003-09-01	7.6
53	1	1518	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	2531	89	38	Serge I	2003-04-08	7.6
24	2	1691	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	336	42	107	Baser	2021-02-27	7.9
8	2	1601	42	94	Serge I	2008-06-21	7.7
22	1	1690	42	12	ZrenBy	2003-09-01	7.4
11	1	2005	41	15	ZrenBy	2003-09-01	7.6
48	1	1210	41	6	Serge I	2009-06-22	7.4
27	1	1342	36	8	Fiolent	2004-02-26	7.4
10	1	837	23	49	Serge I	2017-01-20	8.1
15	1	1294	23	9	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