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

SQL exercises

September 11, 20:45 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	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	224	66513	19	pegoopik	2010-11-20	9.3
40	1	358	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	24	58879	0	aks_nsk	2016-02-05	9.3
220	3	7	58774	1	pegoopik	2016-12-17	10.0
96	3	426	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	147	44295	34	Cyrilus	2005-12-09	9.2
93	3	180	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	111	39776	3	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	570	27534	9	paparome	2006-07-26	8.5
49	2	1230	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	201	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	35	21580	3	$erges	2008-09-08	9.2
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	37	18162	6	@Nikotin	2008-11-09	8.6
147	4	28	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	62	14934	3	paparome	2008-01-22	9.7
19	1	2059	13538	23	Serge I	2004-06-23	7.5
145	3	71	11710	1	pvv	2008-01-07	8.6
164	2	37	11673	2	anddros	2010-04-26	9.7
193	2	22	11363	0	Baser	2012-07-06	8.3
62	2	758	10980	10	Dmitrij Grinkevich	2012-02-11	8.0
106	3	290	10696	6	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	127	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	46	6638	5	pvv	2008-01-01	7.3
222	2	15	6419	0	pegoopik	2016-12-23	9.8
137	4	194	6301	26	Cyrilus	2005-03-06	9.2
141	4	81	6285	11	vlksm	2006-10-29	9.0
77	2	323	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	497	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	96	4315	0	pickman	2011-07-01	8.2
132	3	115	4274	4	risp	2010-01-25	7.6
121	3	414	4274	3	ZrenBy	2004-02-26	7.6
231	3	6	4196	0	mcrain	2018-08-24	10.0
26	1	1539	3980	27	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	70	3206	2	qwrqwr	2013-04-19	9.0
65	3	742	3041	50	Ozzy	2010-01-29	7.7
72	4	1034	2940	150	paparome	2005-12-03	9.2
131	2	97	2931	1	GriGrim	2012-05-25	8.6
107	2	413	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	649	2696	89	Roman Golubin	2006-07-14	9.3
232	3	6	2570	0	al29	2018-08-20	10.0
98	4	596	2563	44	ZrenBy	2003-09-01	8.2
207	3	17	2464	0	pegoopik	2016-01-15	10.0
89	3	426	2412	31	_Bkmz_	2008-06-21	7.9
136	3	118	2361	5	Ozzy	2011-05-12	7.4
302	0	37	2325	0	pegoopik	2012-07-27	7.6
256	1	39	2312	1	anddros	2013-11-08	8.9
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	0	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	34	1874	1	anddros	2013-11-19	8.7
32	3	69	1852	18	blr_Oliver	2023-07-08	9.3
195	3	26	1760	0	Dmitrij Grinkevich	2013-04-20	9.1
76	3	471	1674	15	silver	2010-01-23	8.8
71	3	558	1662	25	anddros	2009-12-26	8.4
125	3	379	1609	3	dimzv	2004-02-29	8.7
166	1	62	1593	1	anddros	2010-07-26	9.5
58	3	665	1540	13	qwrqwr	2013-03-01	8.2
130	2	125	1427	0	anddros	2010-05-22	8.9
142	2	116	1422	1	paparome	2007-03-24	9.0
20	2	1558	1414	32	VIG	2003-09-01	8.0
85	3	380	1374	19	Ozzy	2009-10-10	8.5
84	3	430	1333	18	Ozzy	2009-12-26	8.3
134	3	180	1251	4	pvv	2008-01-22	8.6
202	2	29	1240	0	qwrqwr	2013-11-01	9.1
111	2	462	1226	3	Fiolent	2005-01-19	8.3
197	1	43	1199	0	pegoopik	2013-06-10	8.8
108	3	288	1168	5	crescent	2011-03-23	8.9
110	3	440	1164	11	Snowbear	2006-03-14	8.9
64	3	636	1162	50	qwrqwr	2010-05-13	8.1
105	2	148	1137	0	Baser	2013-09-20	8.6
203	1	41	1134	1	=Maxim=	2013-10-05	9.4
235	2	7	1124	0	Kursist	2021-07-10	9.5
307	2	19	1032	0	Baser	2017-06-29	8.5
80	2	357	1029	10	qwrqwr	2011-10-21	9.0
177	1	53	998	0	pegoopik	2011-07-17	8.5
170	2	55	985	1	qwrqwr	2010-10-24	9.0
66	3	695	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	52	888	0	qwrqwr	2012-02-03	7.8
201	2	38	807	0	Baser	2013-09-21	8.7
129	2	280	773	7	DimaN	2004-03-01	7.5
43	2	575	689	3	qwrqwr	2015-04-24	8.4
23	3	1614	687	125	Palkin	2007-03-29	8.4
305	1	25	684	1	Baser	2017-01-06	9.0
91	2	237	671	1	smog	2012-05-26	9.1
192	2	48	610	0	Baser	2012-03-03	9.2
103	1	149	594	1	Baser	2013-10-05	7.5
82	3	402	572	11	_Virt_	2010-04-27	8.2
118	2	435	565	1	Fiolent	2004-01-05	8.1
75	2	415	558	4	qwrqwr	2011-07-22	7.5
67	2	606	557	17	Ozzy	2010-04-27	8.3
47	3	1000	517	14	qwrqwr	2010-11-20	8.1
54	2	1389	503	45	Ozzy	2008-09-06	8.2
41	3	1168	487	18	qwrqwr	2010-04-26	8.1
68	3	316	483	26	pegoopik	2014-08-01	8.1
79	1	983	483	14	Serge I	2003-06-05	7.8
60	3	2109	462	119	Serge I	2005-03-05	7.9
69	2	194	454	8	Gosha	2017-12-15	9.0
35	3	632	421	13	Baser	2015-09-18	8.7
37	3	814	421	26	qwrqwr	2013-02-22	8.0
86	2	362	396	0	Ozzy	2010-03-05	8.6
109	2	502	385	1	VIG	2003-12-23	8.0
51	1	609	361	14	Fiolent	2004-06-23	8.3
78	2	433	358	5	_ORA_	2010-04-27	7.5
59	2	962	323	6	VIG	2003-12-22	8.3
63	1	1381	320	5	VIG	2003-06-05	7.6
73	1	475	318	3	Ruslan1707	2010-11-02	7.5
38	2	1083	315	25	ZrenBy	2003-09-01	7.5
34	2	1230	305	26	qwrqwr	2010-09-24	7.9
90	1	249	305	1	Dmitrij Grinkevich	2012-03-03	8.0
44	2	786	289	8	Serge I	2011-11-25	7.9
61	2	1012	282	5	risp	2009-12-26	8.5
97	1	382	279	3	dimzv	2004-03-01	7.6
25	2	1291	275	31	DimaN	2004-06-22	7.2
12	1	502	269	47	Serge I	2019-04-12	7.0
74	2	685	265	8	vlksm	2008-06-21	8.3
104	1	149	251	0	pegoopik	2013-07-19	8.4
46	2	1244	249	127	Serge I	2009-08-12	6.8
33	2	1313	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	614	216	6	VIG	2005-06-26	7.8
6	2	2193	211	128	Serge I	2005-05-07	8.0
17	2	1715	208	27	VIG	2003-04-29	8.2
5	1	151	205	114	Serge I	2023-06-18	8.6
236	1	11	198	0	Baser	2021-07-24	9.6
95	1	109	196	2	qwrqwr	2017-12-01	9.4
29	2	1135	194	40	GiBis	2011-09-17	7.5
83	2	551	177	5	lepton	2006-09-29	8.6
18	1	1696	168	10	ZrenBy	2003-09-01	7.7
9	2	1494	165	31	vasia armor	2010-05-21	8.0
70	1	694	164	3	Serge I	2009-04-17	7.9
50	1	591	156	17	mslava	2003-12-23	7.2
94	2	268	150	0	pickman	2011-04-27	8.3
30	1	1810	138	3	Serge I	2003-08-28	7.9
81	2	612	135	12	$erges	2008-05-10	8.3
56	1	1100	129	3	Fiolent	2004-06-22	8.0
52	1	548	123	3	Serge I	2015-01-10	8.6
36	3	1083	123	23	risp	2011-05-06	8.0
16	2	979	116	60	qwrqwr	2014-07-18	7.5
112	1	53	115	2	Gosha	2020-06-03	8.7
42	1	1663	107	15	Serge I	2003-06-05	7.7
21	1	1269	106	9	paparome	2006-03-14	8.0
39	2	1426	103	24	Serge I	2003-08-28	7.5
13	1	1808	98	21	ZrenBy	2003-09-01	7.6
53	1	1513	97	25	DimaN	2004-03-01	7.7
303	2	8	97	0	selber	2023-12-27	8.8
238	2	5	93	0	Baser	2022-05-13	8.0
28	1	1270	92	10	ZrenBy	2003-09-01	7.6
14	1	2521	89	38	Serge I	2003-04-08	7.6
24	2	1683	86	6	Aaz	2004-02-26	7.0
31	1	1103	64	6	Fiolent	2004-06-22	7.9
117	1	438	58	0	Fiolent	2003-12-26	7.7
306	1	13	46	1	Baser	2022-04-29	8.0
7	1	326	42	106	Baser	2021-02-27	7.9
8	2	1592	42	94	Serge I	2008-06-21	7.7
22	1	1682	42	12	ZrenBy	2003-09-01	7.3
11	1	1994	41	16	ZrenBy	2003-09-01	7.5
48	1	1206	41	6	Serge I	2009-06-22	7.4
27	1	1335	36	8	Fiolent	2004-02-26	7.4
10	1	827	23	49	Serge I	2017-01-20	8.0
15	1	1285	23	8	Dmitrij Grinkevich	2012-04-21	7.6
88	2	50	14	1	Serge I	2021-10-15	9.2
301	0	44	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