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

September 25, 13: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.

Ratings

  • 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

Statistics

  • 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)

Forums

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

Certification

  • Certified professionals
  • Statistics
  • Statistics over regions (map)
  • Confirm certificate

HELP

Query optimization

For employers

Support SQL-EX.RU

Rating of 2nd-stage exercises (median)

Rating of second-stage exercises (average)

No - exercise number; Bonus - level of difficulty;
Solved - number of visitors, who have solved this exercise;
Time(min) - the median time (calculated over all participants) 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);
Length - wording length in symbols;
Rank - average score on a result of voting.

No	Bonus	Solved	Time(min)	noOK	Length	Author	Date	Rank
217	4	9	31871	4	549	pegoopik	2015-08-28	9.2 (5)
147	4	26	14593	2	1213	$erges	2010-08-06	9.7 (19)
157	3	24	12925	2	960	anddros	2009-06-05	9.6 (15)
143	5	45	11857	14	946	inkerman	2007-10-07	8.8 (30)
163	3	19	11408	0	1640	Ozzy	2010-01-08	9.6 (14)
214	4	11	10103	0	433	pegoopik	2015-05-30	10.0 (7)
259	4	22	9370	2	276	anddros	2009-08-24	9.5 (13)
155	3	26	8819	2	761	vlksm	2009-04-17	9.9 (18)
216	3	11	8681	1	279	pegoopik	2015-05-15	9.9 (8)
181	4	15	8489	1	1869	Ozzy	2011-10-08	9.7 (10)
194	4	15	7997	1	1461	pegoopik	2012-07-13	10.0 (11)
234	3	4	7476	1	1481	Kursist	2020-02-28	9.5 (2)
253	3	30	7278	7	1097	$erges	2008-05-17	8.9 (20)
230	2	7	6677	1	728	pegoopik	2018-07-27	9.8 (4)
257	4	17	6467	1	2758	pegoopik	2012-02-20	9.4 (13)
138	5	145	6385	33	949	Cyrilus	2005-12-09	9.1 (65)
161	3	21	6370	3	889	Ozzy	2009-11-06	9.2 (17)
224	3	10	6363	0	1979	selber	2017-04-14	9.4 (7)
231	3	5	6186	0	787	mcrain	2018-08-24	10.0 (3)
206	4	14	6127	0	1484	Baser	2013-11-23	9.1 (12)
211	2	14	5791	1	588	Baser	2014-06-30	9.8 (9)
255	4	14	5666	3	793	vlksm	2012-02-14	9.8 (9)
225	2	10	5571	0	737	pegoopik	2017-07-15	9.8 (6)
229	3	6	5468	1	1532	al29	2018-03-23	9.6 (5)
154	4	25	4892	3	848	anddros	2009-03-18	9.9 (17)
160	3	27	4731	0	961	Ozzy	2009-08-07	9.6 (17)
159	3	17	4480	1	565	anddros	2012-07-22	8.2 (14)
220	3	6	4388	1	1175	pegoopik	2016-12-17	10.0 (3)
232	3	5	4384	0	513	al29	2018-08-20	10.0 (4)
191	3	14	4212	0	948	qwrqwr	2012-06-08	9.5 (11)
252	2	34	3918	3	308	Ozzy	2009-06-14	8.3 (23)
149	3	34	3818	2	506	$erges	2008-09-08	9.2 (21)
171	3	19	3682	1	1670	Ozzy	2010-12-05	9.3 (15)
116	5	242	3492	20	469	$erges	2008-12-13	9.4 (115)
218	4	12	3491	2	1500	al29	2016-04-04	9.6 (7)
189	4	15	3350	0	1563	Baser	2012-02-05	8.6 (12)
178	3	23	3302	1	1680	Baser	2011-08-13	9.1 (15)
119	5	104	3203	4	703	Velmont	2014-03-07	9.6 (55)
188	3	17	3191	1	733	qwrqwr	2012-02-04	9.8 (12)
151	3	33	3152	5	1096	anddros	2008-12-30	8.9 (19)
172	3	22	3097	0	1719	Ozzy	2011-03-11	9.8 (16)
208	3	14	3063	0	821	pegoopik	2013-12-20	8.8 (12)
167	3	24	3032	0	674	qwrqwr	2011-01-18	9.9 (15)
156	2	51	3004	3	391	anddros	2009-04-17	9.1 (29)
144	4	45	2996	4	950	pvv	2008-01-01	7.2 (28)
187	3	25	2965	0	978	=Maxim=	2011-12-31	8.8 (20)
100	4	243	2919	12	650	qwrqwr	2010-04-27	9.4 (122)
102	4	179	2786	6	933	GriGrim	2011-07-16	9.5 (83)
153	3	36	2779	4	1539	Ozzy	2009-02-14	9.5 (20)
190	4	16	2521	1	717	vlksm	2012-03-17	8.8 (13)
141	4	79	2335	9	977	vlksm	2006-10-29	9.0 (36)
179	3	17	2329	0	844	pegoopik	2011-09-17	9.2 (12)
101	4	211	2299	14	1096	pegoopik	2010-11-20	9.4 (112)
227	3	9	2137	1	2142	mcrain	2017-12-08	7.0 (5)
210	2	15	2132	0	483	_dimon_	2014-02-07	10.0 (11)
120	4	101	2024	2	239	pegoopik	2014-02-14	9.0 (49)
145	3	69	2007	1	859	pvv	2008-01-07	8.6 (33)
184	2	25	1953	2	432	Baser	2011-11-26	8.8 (19)
164	2	37	1943	1	1622	anddros	2010-04-26	9.7 (22)
148	2	65	1924	7	894	vlksm	2008-09-06	9.3 (35)
98	4	578	1900	44	538	ZrenBy	2003-09-01	8.2 (129)
72	4	1007	1879	150	608	paparome	2005-12-03	9.2 (268)
205	2	16	1877	0	529	qwrqwr	2013-11-22	8.9 (10)
193	2	22	1798	0	522	Baser	2012-07-06	8.3 (15)
182	3	23	1717	0	1377	Baser	2011-10-29	8.1 (17)
87	4	629	1712	90	459	Roman Golubin	2006-07-14	9.3 (174)
222	2	13	1664	1	1475	pegoopik	2016-12-23	9.8 (8)
89	3	407	1662	31	870	_Bkmz_	2008-06-21	7.9 (152)
150	4	36	1652	4	909	@Nikotin	2008-11-09	8.5 (21)
183	2	30	1611	2	518	GriGrim	2011-11-12	9.1 (15)
137	4	190	1607	24	616	Cyrilus	2005-03-06	9.2 (67)
146	3	60	1606	3	949	paparome	2008-01-22	9.7 (33)
223	2	12	1596	0	641	Baser	2016-11-12	9.9 (7)
175	3	30	1548	0	2151	pegoopik	2011-04-28	8.5 (22)
165	2	30	1544	3	1600	vlksm	2010-03-18	9.9 (18)
228	1	18	1540	1	1419	qwrqwr	2018-01-12	10.0 (10)
121	3	402	1529	5	804	ZrenBy	2004-02-26	7.8 (95)
196	3	25	1494	0	661	qwrqwr	2013-05-17	9.4 (15)
176	3	31	1484	0	385	qwrqwr	2011-05-20	9.5 (21)
219	2	16	1482	0	486	pegoopik	2016-04-08	9.9 (8)
136	3	112	1480	5	618	Ozzy	2011-05-12	7.4 (49)
200	3	18	1463	0	1129	qwrqwr	2013-10-05	9.3 (12)
169	3	30	1461	0	1559	Valdaj	2010-09-02	8.4 (21)
132	3	108	1453	4	2500	risp	2010-01-25	7.6 (54)
198	2	23	1444	0	332	Angellore	2013-09-13	9.4 (16)
152	3	46	1420	4	1301	vlksm	2009-01-05	9.7 (27)
123	3	241	1390	38	1254	Ozzy	2009-08-22	9.0 (112)
180	3	32	1375	0	274	qwrqwr	2011-09-16	9.6 (24)
76	3	443	1373	15	949	silver	2010-01-23	8.8 (176)
106	3	279	1362	6	647	vlksm	2008-11-27	8.8 (120)
199	3	20	1350	0	1448	Baser	2013-08-17	8.4 (14)
213	2	26	1346	0	369	qwrqwr	2014-10-17	9.6 (15)
158	3	38	1330	0	1174	Ozzy	2010-04-09	8.9 (23)
215	2	23	1326	0	331	pegoopik	2015-03-06	9.3 (13)
135	3	63	1323	1	854	qwrqwr	2013-04-19	8.9 (33)
212	3	16	1319	0	585	Baser	2014-10-14	8.9 (10)
85	3	360	1290	19	1397	Ozzy	2009-10-10	8.5 (137)
69	2	152	1280	7	210	Gosha	2017-12-15	9.0 (52)
82	3	380	1279	11	1780	_Virt_	2010-04-27	8.3 (140)
77	2	296	1263	32	1053	selber	2015-07-10	8.8 (125)
207	3	16	1255	0	486	pegoopik	2016-01-15	10.0 (8)
68	3	273	1242	24	608	pegoopik	2014-08-01	8.1 (107)
96	3	408	1241	81	572	anddros	2008-11-22	8.8 (161)
226	3	9	1235	2	2054	pegoopik	2017-10-14	9.2 (5)
186	1	37	1215	0	1447	Ozzy	2011-12-30	9.2 (24)
57	1	92	1200	12	537	Kursist	2020-10-10	8.8 (32)
173	1	52	1172	2	945	Ozzy	2011-01-13	9.3 (28)
65	3	688	1165	48	671	Ozzy	2010-01-29	7.7 (247)
168	2	42	1159	2	455	qwrqwr	2010-08-27	9.5 (24)
84	3	410	1157	16	815	Ozzy	2009-12-26	8.4 (148)
93	3	162	1134	5	492	qwrqwr	2014-03-14	9.3 (67)
134	3	173	1041	4	821	pvv	2008-01-22	8.6 (70)
235	2	5	1004	0	665	Kursist	2021-07-10	9.3 (3)
37	3	721	960	25	576	qwrqwr	2013-02-22	8.0 (250)
233	1	14	930	1	2321	pegoopik	2019-03-08	10.0 (7)
140	2	81	925	2	578	_Bkmz_	2010-01-30	8.9 (41)
71	3	529	797	20	941	anddros	2009-12-26	8.4 (185)
125	3	366	735	3	526	dimzv	2004-02-29	8.7 (88)
185	1	43	688	3	782	=Maxim=	2011-11-25	7.9 (25)
110	3	428	673	11	942	Snowbear	2006-03-14	8.9 (112)
221	2	16	669	1	1023	Baser	2016-11-05	8.9 (10)
195	3	26	658	0	722	Dmitrij Grinkevich	2013-04-20	9.1 (15)
126	2	180	633	11	944	$erges	2008-09-07	8.5 (88)
99	3	191	617	8	956	Dmitrij Grinkevich	2012-05-05	8.2 (76)
251	4	68	594	3	850	paparome	2006-10-01	8.0 (29)
162	2	59	592	0	1067	Ozzy	2009-12-26	9.3 (34)
58	3	582	578	10	440	qwrqwr	2013-03-01	8.2 (208)
307	2	19	553	0	1095	Baser	2017-06-29	8.5 (11)
130	2	115	541	0	700	anddros	2010-05-22	8.8 (57)
174	1	56	535	0	1084	qwrqwr	2011-02-25	9.3 (32)
202	2	29	504	0	557	qwrqwr	2013-11-01	9.1 (16)
64	3	575	466	47	508	qwrqwr	2010-05-13	8.0 (181)
66	3	646	463	54	392	anddros	2009-12-26	8.5 (248)
107	2	402	454	9	688	Fiolent	2004-02-26	8.2 (98)
127	2	55	443	2	985	GriGrim	2014-12-21	7.7 (24)
254	1	45	420	1	1383	Baser	2011-09-02	8.8 (27)
45	2	399	402	17	509	dumkan	2016-04-03	8.0 (110)
177	1	53	390	0	935	pegoopik	2011-07-17	8.5 (26)
80	2	334	380	10	453	qwrqwr	2011-10-21	8.9 (135)
142	2	114	379	1	944	paparome	2007-03-24	9.0 (48)
88	3	276	378	5	521	crescent	2011-03-23	8.9 (109)
166	1	59	375	2	449	anddros	2010-07-26	9.6 (30)
23	3	1503	367	122	307	Palkin	2007-03-29	8.4 (365)
115	2	75	360	1	736	selber	2016-05-28	9.1 (31)
170	2	54	332	1	320	qwrqwr	2010-10-24	9.0 (27)
209	1	33	319	1	735	Baser	2013-12-30	8.0 (15)
92	2	552	313	9	405	paparome	2006-07-26	8.5 (120)
139	2	125	310	2	907	Snowbear	2006-09-09	8.3 (44)
36	3	988	300	21	786	risp	2011-05-06	8.0 (304)
111	2	450	277	3	545	Fiolent	2005-01-19	8.3 (97)
47	3	910	274	15	608	qwrqwr	2010-11-20	8.1 (278)
41	3	1079	266	18	271	qwrqwr	2010-04-26	8.1 (345)
29	2	1027	256	40	799	GiBis	2011-09-17	7.5 (330)
60	3	2029	256	119	353	Serge I	2005-03-05	7.8 (325)
54	2	1302	254	46	706	Ozzy	2008-09-06	8.2 (454)
12	1	337	246	44	348	Serge I	2019-04-12	7.2 (85)
262	2	11	243	0	740	selber	2019-06-21	6.5 (6)
118	2	424	234	1	206	Fiolent	2004-01-05	8.2 (88)
133	2	89	233	0	1614	pickman	2011-07-01	8.2 (46)
204	1	34	232	1	366	anddros	2013-11-19	8.7 (17)
67	2	561	226	16	729	Ozzy	2010-04-27	8.3 (198)
91	2	219	224	1	642	smog	2012-05-26	9.1 (87)
105	2	137	219	0	610	Baser	2013-09-20	8.6 (53)
34	2	1128	217	25	765	qwrqwr	2010-09-24	7.9 (346)
122	1	131	207	2	725	Dmitrij Grinkevich	2012-09-14	6.0 (52)
129	2	270	205	7	658	DimaN	2004-03-01	7.5 (57)
43	2	483	204	4	648	qwrqwr	2015-04-24	8.5 (154)
95	1	87	195	3	350	qwrqwr	2017-12-01	9.3 (37)
131	2	88	192	1	498	GriGrim	2012-05-25	8.5 (41)
75	2	388	189	4	644	qwrqwr	2011-07-22	7.5 (141)
40	1	250	189	14	398	Serge I	2018-09-07	7.0 (71)
260	2	52	183	0	999	qwrqwr	2012-02-03	7.7 (35)
20	2	1439	179	35	327	VIG	2003-09-01	8.0 (333)
62	2	677	178	10	446	Dmitrij Grinkevich	2012-02-11	8.0 (215)
86	2	342	177	0	433	Ozzy	2010-03-05	8.6 (113)
49	2	1141	175	22	862	anddros	2009-06-05	7.9 (359)
261	1	35	169	1	1495	Fomichev	2013-12-07	7.0 (19)
61	2	931	166	5	781	risp	2009-12-26	8.5 (311)
55	2	513	165	7	324	VIG	2005-06-26	7.6 (103)
124	2	373	160	3	455	DimaN	2004-02-26	8.3 (84)
203	1	40	160	1	932	=Maxim=	2013-10-05	9.4 (23)
59	2	880	154	5	220	VIG	2003-12-22	8.3 (194)
38	2	987	154	25	302	ZrenBy	2003-09-01	7.6 (197)
304	2	24	151	0	1132	aks_nsk	2016-02-05	9.3 (15)
16	2	851	147	60	336	qwrqwr	2014-07-18	7.4 (245)
74	2	658	143	8	855	vlksm	2008-06-21	8.3 (201)
109	2	491	137	1	671	VIG	2003-12-23	8.0 (96)
201	2	38	127	0	749	Baser	2013-09-21	8.7 (23)
303	2	11	124	0	1634	MikhailYakovlev535	2020-06-23	6.3 (7)
39	2	1335	124	21	256	Serge I	2003-08-28	7.5 (269)
78	2	409	124	3	451	_ORA_	2010-04-27	7.5 (126)
83	2	529	120	5	798	lepton	2006-09-29	8.5 (145)
236	1	6	120	0	467	Baser	2021-07-24	9.5 (4)
81	2	589	118	12	707	$erges	2008-05-10	8.3 (165)
94	2	250	115	0	773	pickman	2011-04-27	8.3 (91)
52	1	458	112	3	274	Serge I	2015-01-10	8.7 (136)
35	3	531	110	11	695	Baser	2015-09-18	8.8 (159)
33	2	1208	110	26	364	DimaN	2004-03-01	7.6 (338)
51	1	519	108	14	410	Fiolent	2004-06-23	8.1 (137)
104	1	138	108	0	571	pegoopik	2013-07-19	8.4 (58)
197	1	43	107	0	518	pegoopik	2013-06-10	8.8 (19)
128	1	224	104	4	829	inkerman	2007-09-14	8.3 (71)
79	1	959	103	14	403	Serge I	2003-06-05	7.7 (154)
44	2	695	102	8	348	Serge I	2011-11-25	7.9 (220)
90	1	231	101	0	499	Dmitrij Grinkevich	2012-03-03	7.8 (80)
305	1	25	101	0	160	Baser	2017-01-06	9.0 (14)
46	2	1155	100	126	376	Serge I	2009-08-12	6.7 (311)
70	1	658	98	3	334	Serge I	2009-04-17	7.9 (216)
6	2	1913	98	43	281	Serge I	2005-05-07	7.9 (326)
73	1	447	96	3	367	Ruslan1707	2010-11-02	7.4 (147)
50	1	790	94	4	414	mslava	2003-12-22	8.3 (177)
7	1	64	94	25	513	Baser	2021-02-27	8.6 (19)
113	1	132	93	0	497	smog	2013-03-29	8.5 (54)
17	2	1592	90	23	122	VIG	2003-04-29	8.1 (313)
103	1	138	86	1	850	Baser	2013-10-05	7.4 (54)
114	1	448	83	4	298	Serge I	2003-12-24	8.4 (92)
256	1	39	82	1	436	anddros	2013-11-08	8.9 (20)
24	2	1571	79	6	685	Aaz	2004-02-26	6.9 (447)
10	1	664	79	46	179	Serge I	2017-01-20	7.9 (191)
25	2	1180	78	29	232	DimaN	2004-06-22	7.0 (313)
26	1	1432	74	24	289	VIG	2003-12-22	7.7 (350)
9	2	1336	72	31	498	vasia armor	2010-05-21	7.9 (397)
28	1	1162	66	11	283	ZrenBy	2003-09-01	7.6 (224)
8	2	1415	66	94	600	Serge I	2008-06-21	7.6 (359)
21	1	1153	63	10	709	paparome	2006-03-14	8.0 (267)
97	1	363	63	3	231	dimzv	2004-03-01	7.7 (78)
112	1	31	62	2	393	Gosha	2020-06-03	9.0 (16)
32	1	1312	61	7	603	Roman Golubin	2005-12-13	7.5 (304)
42	1	1577	56	14	254	Serge I	2003-06-05	7.6 (307)
117	1	426	55	0	193	Fiolent	2003-12-26	7.6 (83)
18	1	1578	53	7	157	ZrenBy	2003-09-01	7.7 (350)
192	2	48	52	0	709	Baser	2012-03-03	9.2 (25)
27	1	1227	51	8	376	Fiolent	2004-02-26	7.3 (286)
48	1	1116	51	6	317	Serge I	2009-06-22	7.4 (296)
30	1	1703	50	3	205	Serge I	2003-08-28	7.9 (379)
56	1	1014	48	3	581	Fiolent	2004-06-22	7.9 (268)
19	1	1944	47	23	269	Serge I	2004-06-23	7.5 (403)
14	1	2393	47	36	116	Serge I	2003-04-08	7.5 (420)
108	1	494	47	0	412	mslava	2003-12-23	7.4 (93)
22	1	1568	46	12	270	ZrenBy	2003-09-01	7.3 (364)
31	1	994	45	7	349	Fiolent	2004-06-22	7.9 (247)
63	1	1300	45	5	190	VIG	2003-06-05	7.6 (236)
302	0	37	45	0	510	pegoopik	2012-07-27	7.6 (11)
53	1	1427	39	25	230	DimaN	2004-03-01	7.6 (371)
13	1	1673	39	21	194	ZrenBy	2003-09-01	7.5 (395)
15	1	1155	35	8	287	Dmitrij Grinkevich	2012-04-21	7.5 (313)
11	1	1847	34	15	130	ZrenBy	2003-09-01	7.5 (424)
258	3	25	13	0	1070	Baser	2014-09-19	7.6 (10)
301	0	43	8	0	55	pegoopik	2012-03-23	8.9 (20)
306	1	10	5	0	258	Baser	2021-02-26	9.3 (4)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References