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

SQL exercises

December 21, 15:17 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	227	66513	19	pegoopik	2010-11-20	9.3
40	1	370	64581	10	Serge I	2018-09-07	7.0
102	4	193	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	429	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	183	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	114	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	210	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	573	27534	9	paparome	2006-07-26	8.5
49	2	1240	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	215	23844	15	Kursist	2020-10-10	8.4
154	4	28	23397	3	anddros	2009-03-18	9.9
186	1	37	23332	0	Ozzy	2011-12-30	9.2
119	5	118	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	256	19323	20	$erges	2008-12-13	9.4
126	2	192	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	4	anddros	2009-04-17	9.1
122	1	144	15140	2	Dmitrij Grinkevich	2012-09-14	5.8
146	3	63	14934	3	paparome	2008-01-22	9.7
19	1	2071	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	769	10980	11	Dmitrij Grinkevich	2012-02-11	8.1
106	3	294	10696	5	vlksm	2008-11-27	8.8
100	4	264	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	91	7699	1	selber	2016-05-28	9.0
139	2	128	7537	2	Snowbear	2006-09-09	8.3
155	3	29	7331	2	vlksm	2009-04-17	10.0
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	328	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	509	4709	14	dumkan	2016-04-03	8.0
123	3	255	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	416	4274	4	ZrenBy	2004-02-26	7.6
231	3	6	4196	0	mcrain	2018-08-24	10.0
26	1	1549	3980	29	VIG	2003-12-22	7.7
127	2	66	3702	3	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	748	3041	51	Ozzy	2010-01-29	7.7
72	4	1040	2940	149	paparome	2005-12-03	9.2
131	2	98	2931	1	GriGrim	2012-05-25	8.6
107	2	417	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	652	2696	89	Roman Golubin	2006-07-14	9.3
232	3	6	2570	0	al29	2018-08-20	10.0
98	4	599	2563	44	ZrenBy	2003-09-01	8.2
207	3	17	2464	0	pegoopik	2016-01-15	10.0
89	3	429	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	87	1852	17	blr_Oliver	2023-07-08	9.3
195	3	27	1760	0	Dmitrij Grinkevich	2013-04-20	9.1
76	3	477	1674	15	silver	2010-01-23	8.8
71	3	563	1662	24	anddros	2009-12-26	8.4
125	3	381	1609	3	dimzv	2004-02-29	8.7
166	1	63	1593	1	anddros	2010-07-26	9.6
58	3	677	1540	13	qwrqwr	2013-03-01	8.1
130	2	125	1427	0	anddros	2010-05-22	8.9
142	2	117	1422	1	paparome	2007-03-24	9.0
20	2	1569	1414	33	VIG	2003-09-01	8.0
85	3	384	1374	18	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	465	1226	3	Fiolent	2005-01-19	8.3
197	1	44	1199	0	pegoopik	2013-06-10	8.9
108	3	291	1168	5	crescent	2011-03-23	8.9
110	3	443	1164	12	Snowbear	2006-03-14	8.9
64	3	644	1162	50	qwrqwr	2010-05-13	8.1
105	2	151	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	361	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	55	anddros	2009-12-26	8.5
124	2	387	970	3	DimaN	2004-02-26	8.2
114	1	463	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	586	689	3	qwrqwr	2015-04-24	8.4
23	3	1626	687	125	Palkin	2007-03-29	8.4
305	1	26	684	1	Baser	2017-01-06	9.1
91	2	240	671	1	smog	2012-05-26	9.1
192	2	49	610	0	Baser	2012-03-03	9.2
103	1	152	594	1	Baser	2013-10-05	7.5
82	3	404	572	12	_Virt_	2010-04-27	8.2
118	2	438	565	1	Fiolent	2004-01-05	8.1
75	2	422	558	4	qwrqwr	2011-07-22	7.5
67	2	611	557	18	Ozzy	2010-04-27	8.3
47	3	1011	517	14	qwrqwr	2010-11-20	8.2
54	2	1400	503	45	Ozzy	2008-09-06	8.2
41	3	1179	487	18	qwrqwr	2010-04-26	8.1
68	3	321	483	27	pegoopik	2014-08-01	8.1
79	1	987	483	14	Serge I	2003-06-05	7.8
60	3	2120	462	119	Serge I	2005-03-05	7.9
69	2	199	454	8	Gosha	2017-12-15	9.1
35	3	645	421	12	Baser	2015-09-18	8.7
37	3	826	421	25	qwrqwr	2013-02-22	8.0
86	2	365	396	0	Ozzy	2010-03-05	8.6
109	2	506	385	1	VIG	2003-12-23	8.0
51	1	621	361	14	Fiolent	2004-06-23	8.3
78	2	438	358	5	_ORA_	2010-04-27	7.5
59	2	973	323	6	VIG	2003-12-22	8.3
63	1	1391	320	5	VIG	2003-06-05	7.6
73	1	482	318	3	Ruslan1707	2010-11-02	7.5
38	2	1093	315	26	ZrenBy	2003-09-01	7.5
34	2	1241	305	26	qwrqwr	2010-09-24	7.9
90	1	253	305	1	Dmitrij Grinkevich	2012-03-03	8.0
44	2	797	289	8	Serge I	2011-11-25	7.9
61	2	1023	282	5	risp	2009-12-26	8.5
97	1	385	279	3	dimzv	2004-03-01	7.6
25	2	1303	275	31	DimaN	2004-06-22	7.2
12	1	518	269	47	Serge I	2019-04-12	7.0
74	2	691	265	8	vlksm	2008-06-21	8.3
104	1	152	251	0	pegoopik	2013-07-19	8.4
46	2	1254	249	127	Serge I	2009-08-12	6.9
33	2	1323	227	26	DimaN	2004-03-01	7.7
128	1	235	225	4	inkerman	2007-09-14	8.4
113	1	147	218	0	smog	2013-03-29	8.7
55	2	625	216	6	VIG	2005-06-26	7.8
6	2	2206	211	127	Serge I	2005-05-07	8.0
17	2	1728	208	27	VIG	2003-04-29	8.2
5	1	172	205	142	Serge I	2023-06-18	8.6
236	1	12	198	0	Baser	2021-07-24	9.7
95	1	112	196	2	qwrqwr	2017-12-01	9.4
29	2	1146	194	40	GiBis	2011-09-17	7.5
83	2	553	177	5	lepton	2006-09-29	8.6
18	1	1708	168	12	ZrenBy	2003-09-01	7.7
9	2	1508	165	31	vasia armor	2010-05-21	8.0
70	1	698	164	3	Serge I	2009-04-17	7.9
50	1	604	156	16	mslava	2003-12-23	7.1
94	2	271	150	0	pickman	2011-04-27	8.3
30	1	1820	138	3	Serge I	2003-08-28	7.9
81	2	615	135	12	$erges	2008-05-10	8.3
56	1	1111	129	3	Fiolent	2004-06-22	8.0
52	1	561	123	3	Serge I	2015-01-10	8.6
36	3	1094	123	23	risp	2011-05-06	8.0
16	2	993	116	60	qwrqwr	2014-07-18	7.5
112	1	56	115	2	Gosha	2020-06-03	8.7
42	1	1673	107	15	Serge I	2003-06-05	7.7
21	1	1280	106	9	paparome	2006-03-14	8.0
39	2	1436	103	24	Serge I	2003-08-28	7.5
13	1	1821	98	22	ZrenBy	2003-09-01	7.6
53	1	1524	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	1280	92	10	ZrenBy	2003-09-01	7.6
14	1	2534	89	38	Serge I	2003-04-08	7.6
24	2	1695	86	6	Aaz	2004-02-26	7.0
31	1	1113	64	6	Fiolent	2004-06-22	7.9
117	1	441	58	0	Fiolent	2003-12-26	7.7
306	1	14	46	1	Baser	2022-04-29	8.3
7	1	343	42	107	Baser	2021-02-27	8.0
8	2	1604	42	94	Serge I	2008-06-21	7.7
22	1	1694	42	12	ZrenBy	2003-09-01	7.3
11	1	2008	41	15	ZrenBy	2003-09-01	7.6
48	1	1216	41	6	Serge I	2009-06-22	7.4
27	1	1345	36	8	Fiolent	2004-02-26	7.4
10	1	842	23	49	Serge I	2017-01-20	8.1
15	1	1299	23	8	Dmitrij Grinkevich	2012-04-21	7.6
88	2	55	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