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

April 28, 02:56 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
  • Data simulation (DML);
  • Visual simulation (painting)
  • Exercises voting (SELECT)
  • Exercises voting (DML)

Forums

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

Certification

  • About 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
263	4	9	31871	5	587	pegoopik	2015-08-28	9.2 (5)
237	3	4	15761	1	1161	Baser	2022-05-13	9.7 (3)
147	4	29	14593	2	1251	$erges	2010-08-06	9.7 (20)
157	3	25	13065	3	998	anddros	2009-06-05	9.6 (16)
217	2	4	13034	0	310	pegoopik	2025-02-14	8.7 (3)
163	3	20	11408	0	1678	Ozzy	2010-01-08	9.7 (15)
143	5	48	11333	14	1197	inkerman	2007-10-07	8.8 (32)
214	4	11	10103	0	471	pegoopik	2015-05-30	10.0 (7)
155	3	29	10042	2	799	vlksm	2009-04-17	10.0 (20)
259	4	22	9370	2	314	anddros	2009-08-24	9.5 (13)
216	3	11	8681	1	317	pegoopik	2015-05-15	9.9 (8)
181	4	15	8489	1	1907	Ozzy	2011-10-08	9.7 (10)
194	4	15	7997	2	1499	pegoopik	2012-07-13	10.0 (11)
253	3	30	7278	8	1135	$erges	2008-05-17	8.9 (20)
161	3	23	6968	3	927	Ozzy	2009-11-06	9.3 (18)
257	4	17	6467	1	2796	pegoopik	2012-02-20	9.4 (13)
138	5	149	6385	35	987	Cyrilus	2005-12-09	9.2 (67)
224	3	11	6363	0	2017	selber	2017-04-14	9.5 (8)
206	4	14	6127	0	1522	Baser	2013-11-23	9.1 (12)
234	3	6	6045	1	1519	Kursist	2020-02-28	9.8 (4)
230	2	8	5920	1	766	pegoopik	2018-07-27	9.8 (5)
231	3	6	5903	0	825	mcrain	2018-08-24	10.0 (4)
211	2	14	5791	1	626	Baser	2014-06-30	9.8 (9)
255	4	14	5666	4	831	vlksm	2012-02-14	9.8 (9)
225	2	11	5571	0	775	pegoopik	2017-07-15	9.9 (7)
229	3	7	5468	1	1570	al29	2018-03-23	9.7 (6)
154	4	28	4892	3	886	anddros	2009-03-18	9.9 (19)
160	3	28	4731	0	999	Ozzy	2009-08-07	9.6 (18)
190	4	17	4683	1	755	vlksm	2012-03-17	8.9 (14)
159	3	18	4480	1	603	anddros	2012-07-22	8.2 (14)
220	3	7	4388	1	1213	pegoopik	2016-12-17	10.0 (4)
191	3	14	4212	0	986	qwrqwr	2012-06-08	9.5 (11)
252	2	35	3918	3	346	Ozzy	2009-06-14	8.4 (23)
149	3	36	3891	3	544	$erges	2008-09-08	9.3 (22)
171	3	19	3682	1	1708	Ozzy	2010-12-05	9.3 (15)
218	4	13	3491	2	1538	al29	2016-04-04	9.6 (8)
116	5	256	3479	21	507	$erges	2008-12-13	9.4 (126)
189	4	15	3350	0	1601	Baser	2012-02-05	8.6 (12)
178	3	23	3302	1	1718	Baser	2011-08-13	9.1 (15)
151	3	37	3290	4	1134	anddros	2008-12-30	8.9 (21)
188	3	17	3191	1	771	qwrqwr	2012-02-04	9.8 (12)
172	3	22	3097	0	1757	Ozzy	2011-03-11	9.8 (16)
167	3	25	3087	1	712	qwrqwr	2011-01-18	9.9 (15)
208	3	14	3063	0	859	pegoopik	2013-12-20	8.8 (12)
153	3	39	3047	4	1577	Ozzy	2009-02-14	9.3 (21)
156	2	53	3030	3	429	anddros	2009-04-17	9.1 (30)
144	4	47	2996	4	988	pvv	2008-01-01	7.4 (30)
187	3	26	2965	0	1016	=Maxim=	2011-12-31	8.8 (21)
119	5	119	2943	4	742	Velmont	2014-03-07	9.6 (64)
232	3	6	2940	0	551	al29	2018-08-20	10.0 (5)
100	4	266	2916	10	688	qwrqwr	2010-04-27	9.4 (135)
221	2	17	2539	1	1061	Baser	2016-11-05	8.9 (10)
102	4	194	2387	8	971	GriGrim	2011-07-16	9.5 (93)
223	2	13	2357	0	679	Baser	2016-11-12	9.9 (8)
141	4	81	2335	12	1015	vlksm	2006-10-29	9.0 (36)
179	3	17	2329	0	882	pegoopik	2011-09-17	9.2 (12)
210	2	15	2132	0	521	_dimon_	2014-02-07	10.0 (11)
101	4	229	2125	20	1134	pegoopik	2010-11-20	9.3 (123)
145	3	72	2007	1	897	pvv	2008-01-07	8.7 (34)
184	2	26	1953	1	470	Baser	2011-11-26	8.9 (20)
227	3	10	1948	1	2180	mcrain	2017-12-08	7.3 (6)
164	2	38	1943	2	1660	anddros	2010-04-26	9.7 (22)
98	4	600	1912	44	576	ZrenBy	2003-09-01	8.2 (139)
148	2	68	1910	7	932	vlksm	2008-09-06	9.3 (36)
72	4	1043	1882	149	646	paparome	2005-12-03	9.2 (286)
205	2	16	1877	0	567	qwrqwr	2013-11-22	8.9 (10)
120	4	116	1834	2	277	pegoopik	2014-02-14	9.1 (58)
193	2	22	1798	0	560	Baser	2012-07-06	8.3 (15)
150	4	38	1780	6	947	@Nikotin	2008-11-09	8.6 (22)
182	3	23	1717	0	1415	Baser	2011-10-29	8.1 (17)
222	2	15	1664	0	1513	pegoopik	2016-12-23	9.8 (9)
89	3	430	1637	31	908	_Bkmz_	2008-06-21	7.9 (164)
137	4	198	1618	25	654	Cyrilus	2005-03-06	9.2 (70)
183	2	30	1611	2	556	GriGrim	2011-11-12	9.1 (15)
146	3	63	1606	3	987	paparome	2008-01-22	9.7 (34)
87	4	653	1604	89	497	Roman Golubin	2006-07-14	9.3 (184)
200	3	19	1586	0	1167	qwrqwr	2013-10-05	9.3 (13)
175	3	30	1548	1	2189	pegoopik	2011-04-28	8.5 (22)
165	2	32	1544	3	1638	vlksm	2010-03-18	9.8 (19)
228	1	19	1540	1	1457	qwrqwr	2018-01-12	10.0 (11)
121	3	417	1529	4	842	ZrenBy	2004-02-26	7.6 (103)
136	3	121	1519	5	656	Ozzy	2011-05-12	7.5 (53)
169	3	32	1519	0	1597	Valdaj	2010-09-02	8.5 (22)
196	3	25	1494	0	699	qwrqwr	2013-05-17	9.4 (15)
176	3	32	1484	0	423	qwrqwr	2011-05-20	9.5 (22)
135	3	72	1483	2	892	qwrqwr	2013-04-19	9.1 (38)
219	2	17	1482	0	525	pegoopik	2016-04-08	9.9 (9)
132	3	117	1472	5	2538	risp	2010-01-25	7.5 (58)
158	3	39	1452	0	1212	Ozzy	2010-04-09	8.9 (23)
198	2	23	1444	1	370	Angellore	2013-09-13	9.4 (16)
152	3	49	1420	4	1339	vlksm	2009-01-05	9.6 (28)
233	1	17	1394	0	2359	pegoopik	2019-03-08	10.0 (9)
180	3	32	1375	0	312	qwrqwr	2011-09-16	9.6 (24)
68	3	325	1372	28	646	pegoopik	2014-08-01	8.1 (123)
85	3	388	1368	18	1435	Ozzy	2009-10-10	8.5 (153)
199	3	20	1350	0	1486	Baser	2013-08-17	8.4 (14)
213	2	26	1346	0	407	qwrqwr	2014-10-17	9.6 (15)
76	3	480	1344	15	987	silver	2010-01-23	8.8 (191)
215	2	23	1326	0	369	pegoopik	2015-03-06	9.3 (13)
212	3	16	1319	0	623	Baser	2014-10-14	8.9 (10)
168	2	43	1310	2	493	qwrqwr	2010-08-27	9.5 (25)
123	3	256	1306	38	1292	Ozzy	2009-08-22	9.0 (120)
82	3	410	1289	12	1818	_Virt_	2010-04-27	8.2 (154)
207	3	17	1255	0	524	pegoopik	2016-01-15	10.0 (9)
226	3	11	1235	1	2092	pegoopik	2017-10-14	9.3 (6)
69	2	202	1223	8	248	Gosha	2017-12-15	9.1 (69)
186	1	37	1215	0	1485	Ozzy	2011-12-30	9.2 (24)
106	3	294	1206	5	685	vlksm	2008-11-27	8.8 (129)
77	2	334	1194	31	1091	selber	2015-07-10	8.7 (138)
173	1	52	1172	3	983	Ozzy	2011-01-13	9.3 (28)
84	3	437	1157	17	853	Ozzy	2009-12-26	8.3 (162)
65	3	752	1152	52	710	Ozzy	2010-01-29	7.7 (263)
96	3	430	1139	81	610	anddros	2008-11-22	8.8 (171)
93	3	185	1086	5	530	qwrqwr	2014-03-14	9.3 (78)
57	2	217	1061	16	575	Kursist	2020-10-10	8.4 (65)
134	3	182	1041	4	859	pvv	2008-01-22	8.6 (73)
140	2	84	925	2	616	_Bkmz_	2010-01-30	8.9 (42)
32	3	94	924	21	514	blr_Oliver	2023-07-08	9.1 (33)
37	3	828	866	25	614	qwrqwr	2013-02-22	8.0 (276)
71	3	566	805	24	979	anddros	2009-12-26	8.4 (198)
125	3	381	704	3	564	dimzv	2004-02-29	8.7 (95)
185	1	44	688	3	820	=Maxim=	2011-11-25	7.9 (26)
195	3	27	658	0	760	Dmitrij Grinkevich	2013-04-20	9.1 (16)
126	2	194	633	11	982	$erges	2008-09-07	8.6 (95)
110	3	444	626	11	980	Snowbear	2006-03-14	8.9 (123)
251	4	68	594	3	888	paparome	2006-10-01	8.0 (29)
162	2	60	592	1	1105	Ozzy	2009-12-26	9.3 (34)
307	2	19	553	0	1133	Baser	2017-06-29	8.5 (11)
174	1	56	535	0	1122	qwrqwr	2011-02-25	9.3 (32)
130	2	128	534	0	738	anddros	2010-05-22	8.9 (63)
58	3	679	532	13	435	qwrqwr	2013-03-01	8.1 (234)
107	2	417	515	9	726	Fiolent	2004-02-26	8.0 (108)
202	2	29	504	1	595	qwrqwr	2013-11-01	9.1 (16)
99	3	213	471	8	994	Dmitrij Grinkevich	2012-05-05	8.2 (88)
66	3	704	461	55	430	anddros	2009-12-26	8.5 (260)
254	1	45	420	1	1421	Baser	2011-09-02	8.8 (27)
127	2	70	406	2	1023	GriGrim	2014-12-21	8.2 (32)
177	1	53	390	0	973	pegoopik	2011-07-17	8.5 (26)
5	1	193	388	159	262	Serge I	2023-06-18	8.5 (60)
142	2	118	379	1	982	paparome	2007-03-24	9.0 (49)
166	1	63	375	1	487	anddros	2010-07-26	9.6 (32)
64	3	650	366	51	544	qwrqwr	2010-05-13	8.1 (202)
80	2	365	360	11	491	qwrqwr	2011-10-21	9.0 (145)
23	3	1631	357	125	345	Palkin	2007-03-29	8.4 (393)
115	2	93	348	1	774	selber	2016-05-28	9.0 (42)
170	2	57	347	1	358	qwrqwr	2010-10-24	9.1 (29)
108	3	292	331	5	559	crescent	2011-03-23	8.9 (119)
209	1	33	319	1	773	Baser	2013-12-30	8.0 (15)
92	2	574	303	9	443	paparome	2006-07-26	8.5 (129)
139	2	129	295	2	945	Snowbear	2006-09-09	8.3 (46)
12	1	526	280	48	386	Serge I	2019-04-12	7.0 (122)
111	2	466	271	3	583	Fiolent	2005-01-19	8.3 (106)
36	3	1096	269	23	824	risp	2011-05-06	8.0 (330)
29	2	1151	256	40	837	GiBis	2011-09-17	7.5 (353)
47	3	1014	253	14	592	qwrqwr	2010-11-20	8.1 (310)
54	2	1402	248	45	834	Ozzy	2008-09-06	8.2 (482)
41	3	1182	248	18	291	qwrqwr	2010-04-26	8.1 (374)
45	2	512	247	14	511	dumkan	2016-04-03	8.0 (140)
262	2	14	243	2	778	selber	2019-06-21	8.3 (7)
204	1	36	241	1	404	anddros	2013-11-19	8.5 (19)
67	2	617	240	17	767	Ozzy	2010-04-27	8.3 (216)
60	3	2122	232	119	351	Serge I	2005-03-05	7.9 (351)
118	2	438	228	1	244	Fiolent	2004-01-05	8.1 (95)
91	2	242	218	1	680	smog	2012-05-26	9.1 (98)
133	2	98	215	0	1652	pickman	2011-07-01	8.3 (49)
34	2	1244	207	26	803	qwrqwr	2010-09-24	7.9 (372)
105	2	152	206	0	648	Baser	2013-09-20	8.6 (60)
129	2	282	205	8	696	DimaN	2004-03-01	7.5 (63)
122	1	146	198	2	763	Dmitrij Grinkevich	2012-09-14	5.9 (60)
43	2	589	198	3	635	qwrqwr	2015-04-24	8.4 (185)
95	1	114	192	2	388	qwrqwr	2017-12-01	9.4 (46)
75	2	425	188	4	682	qwrqwr	2011-07-22	7.5 (154)
260	2	53	183	0	1039	qwrqwr	2012-02-03	7.7 (37)
40	1	373	180	10	436	Serge I	2018-09-07	7.0 (97)
20	2	1575	179	34	365	VIG	2003-09-01	8.0 (355)
62	2	772	178	10	614	Dmitrij Grinkevich	2012-02-11	8.1 (240)
86	2	367	177	0	471	Ozzy	2010-03-05	8.6 (124)
261	1	35	169	1	1533	Fomichev	2013-12-07	7.0 (19)
59	2	975	168	6	241	VIG	2003-12-22	8.3 (218)
38	2	1095	168	26	340	ZrenBy	2003-09-01	7.5 (222)
49	2	1243	166	22	929	anddros	2009-06-05	7.9 (388)
61	2	1025	161	5	810	risp	2009-12-26	8.5 (334)
124	2	387	160	3	493	DimaN	2004-02-26	8.2 (91)
7	1	354	158	110	551	Baser	2021-02-27	8.0 (80)
304	2	25	151	0	1170	aks_nsk	2016-02-05	9.4 (16)
74	2	694	143	8	893	vlksm	2008-06-21	8.4 (214)
131	2	101	142	1	536	GriGrim	2012-05-25	8.7 (47)
203	1	42	139	1	970	=Maxim=	2013-10-05	9.4 (25)
16	2	1000	132	60	374	qwrqwr	2014-07-18	7.5 (267)
109	2	506	128	1	709	VIG	2003-12-23	8.0 (102)
201	2	39	127	0	787	Baser	2013-09-21	8.8 (24)
303	2	12	127	0	725	selber	2023-12-27	9.3 (7)
39	2	1439	126	23	294	Serge I	2003-08-28	7.5 (294)
78	2	442	124	5	489	_ORA_	2010-04-27	7.5 (135)
83	2	558	120	5	836	lepton	2006-09-29	8.6 (157)
51	1	623	119	14	454	Fiolent	2004-06-23	8.3 (166)
55	2	628	118	6	377	VIG	2005-06-26	7.8 (127)
81	2	619	118	12	745	$erges	2008-05-10	8.3 (175)
94	2	273	111	0	811	pickman	2011-04-27	8.3 (98)
35	3	648	110	11	733	Baser	2015-09-18	8.7 (191)
235	2	9	110	0	703	Kursist	2021-07-10	9.7 (6)
33	2	1326	108	26	402	DimaN	2004-03-01	7.7 (360)
236	1	12	106	0	505	Baser	2021-07-24	9.7 (9)
104	1	153	104	0	609	pegoopik	2013-07-19	8.4 (66)
128	1	238	104	4	867	inkerman	2007-09-14	8.4 (77)
79	1	991	102	14	441	Serge I	2003-06-05	7.8 (162)
197	1	45	102	0	556	pegoopik	2013-06-10	8.9 (20)
44	2	800	99	8	311	Serge I	2011-11-25	7.9 (249)
17	2	1736	99	26	160	VIG	2003-04-29	8.2 (339)
90	1	254	99	1	537	Dmitrij Grinkevich	2012-03-03	8.0 (90)
73	1	485	97	3	405	Ruslan1707	2010-11-02	7.5 (159)
52	1	563	96	3	306	Serge I	2015-01-10	8.6 (162)
46	2	1258	95	126	378	Serge I	2009-08-12	6.9 (335)
70	1	701	94	3	372	Serge I	2009-04-17	7.9 (228)
6	2	2219	94	126	319	Serge I	2005-05-07	8.0 (396)
113	1	149	92	0	535	smog	2013-03-29	8.7 (62)
305	1	26	91	1	198	Baser	2017-01-06	9.1 (15)
103	1	153	87	1	888	Baser	2013-10-05	7.6 (63)
114	1	464	83	4	336	Serge I	2003-12-24	8.5 (101)
256	1	40	82	1	474	anddros	2013-11-08	9.0 (21)
238	2	7	81	0	1181	Baser	2022-05-13	8.6 (5)
24	2	1700	79	6	723	Aaz	2004-02-26	7.0 (470)
26	1	1554	79	28	327	VIG	2003-12-22	7.7 (369)
25	2	1307	75	32	270	DimaN	2004-06-22	7.2 (337)
9	2	1517	72	31	536	vasia armor	2010-05-21	8.0 (436)
10	1	852	72	48	218	Serge I	2017-01-20	8.1 (234)
50	1	608	72	16	459	mslava	2003-12-23	7.1 (123)
28	1	1285	70	10	321	ZrenBy	2003-09-01	7.6 (244)
112	1	58	69	2	431	Gosha	2020-06-03	8.7 (26)
8	2	1613	67	94	638	Serge I	2008-06-21	7.7 (398)
21	1	1285	63	10	747	paparome	2006-03-14	8.1 (289)
97	1	386	63	3	269	dimzv	2004-03-01	7.6 (87)
18	1	1716	56	12	195	ZrenBy	2003-09-01	7.7 (372)
42	1	1676	55	15	287	Serge I	2003-06-05	7.7 (334)
239	2	4	54	0	464	pegoopik	2025-02-21	9.3 (3)
192	2	50	52	0	747	Baser	2012-03-03	9.2 (26)
117	1	441	52	0	231	Fiolent	2003-12-26	7.7 (91)
27	1	1350	51	8	414	Fiolent	2004-02-26	7.4 (310)
30	1	1825	50	3	243	Serge I	2003-08-28	7.9 (405)
48	1	1219	50	6	290	Serge I	2009-06-22	7.4 (322)
22	1	1699	48	12	308	ZrenBy	2003-09-01	7.4 (391)
14	1	2541	47	38	154	Serge I	2003-04-08	7.6 (449)
19	1	2078	47	23	307	Serge I	2004-06-23	7.5 (424)
63	1	1394	47	5	228	VIG	2003-06-05	7.6 (253)
56	1	1113	46	3	603	Fiolent	2004-06-22	8.0 (289)
88	2	56	45	1	331	Serge I	2021-10-15	9.2 (19)
302	0	38	45	0	548	pegoopik	2012-07-27	7.8 (12)
31	1	1118	43	6	387	Fiolent	2004-06-22	7.9 (273)
13	1	1828	40	22	232	ZrenBy	2003-09-01	7.6 (421)
53	1	1526	37	25	272	DimaN	2004-03-01	7.7 (393)
15	1	1307	36	7	325	Dmitrij Grinkevich	2012-04-21	7.6 (339)
11	1	2017	35	16	169	ZrenBy	2003-09-01	7.6 (451)
306	1	15	30	1	401	Baser	2022-04-29	8.3 (8)
258	3	25	13	1	1108	Baser	2014-09-19	7.6 (10)
301	0	45	8	0	93	pegoopik	2012-03-23	8.7 (22)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References