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

November 21, 12:14 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
237	3	3	463867	1	1123	Baser	2022-05-13	9.5 (2)
217	4	9	31871	4	549	pegoopik	2015-08-28	9.2 (5)
147	4	29	14593	2	1213	$erges	2010-08-06	9.7 (20)
157	3	24	12925	3	960	anddros	2009-06-05	9.6 (15)
163	3	19	11408	0	1640	Ozzy	2010-01-08	9.6 (14)
143	5	47	11333	14	946	inkerman	2007-10-07	8.8 (31)
214	4	11	10103	0	433	pegoopik	2015-05-30	10.0 (7)
155	3	28	9893	2	761	vlksm	2009-04-17	9.9 (19)
259	4	22	9370	2	276	anddros	2009-08-24	9.5 (13)
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	2	1461	pegoopik	2012-07-13	10.0 (11)
234	3	5	7476	1	1481	Kursist	2020-02-28	9.7 (3)
253	3	30	7278	8	1097	$erges	2008-05-17	8.9 (20)
257	4	17	6467	1	2758	pegoopik	2012-02-20	9.4 (13)
161	3	22	6370	3	889	Ozzy	2009-11-06	9.3 (18)
224	3	11	6363	0	1979	selber	2017-04-14	9.5 (8)
138	5	148	6228	35	949	Cyrilus	2005-12-09	9.2 (67)
206	4	14	6127	0	1484	Baser	2013-11-23	9.1 (12)
230	2	8	5920	1	728	pegoopik	2018-07-27	9.8 (5)
231	3	6	5903	0	787	mcrain	2018-08-24	10.0 (4)
211	2	14	5791	1	588	Baser	2014-06-30	9.8 (9)
255	4	14	5666	4	793	vlksm	2012-02-14	9.8 (9)
225	2	11	5571	0	737	pegoopik	2017-07-15	9.9 (7)
229	3	7	5468	1	1532	al29	2018-03-23	9.7 (6)
154	4	27	4892	4	848	anddros	2009-03-18	9.9 (18)
160	3	27	4731	0	961	Ozzy	2009-08-07	9.6 (17)
190	4	17	4683	1	717	vlksm	2012-03-17	8.9 (14)
159	3	17	4480	1	565	anddros	2012-07-22	8.2 (14)
220	3	7	4388	1	1175	pegoopik	2016-12-17	10.0 (4)
191	3	14	4212	0	948	qwrqwr	2012-06-08	9.5 (11)
252	2	35	3918	3	308	Ozzy	2009-06-14	8.4 (23)
149	3	36	3891	3	506	$erges	2008-09-08	9.3 (22)
171	3	19	3682	1	1670	Ozzy	2010-12-05	9.3 (15)
116	5	253	3492	21	469	$erges	2008-12-13	9.4 (124)
218	4	13	3491	2	1500	al29	2016-04-04	9.6 (8)
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)
151	3	37	3290	4	1096	anddros	2008-12-30	8.9 (21)
188	3	17	3191	1	733	qwrqwr	2012-02-04	9.8 (12)
119	5	115	3102	4	703	Velmont	2014-03-07	9.6 (62)
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)
153	3	39	3047	4	1539	Ozzy	2009-02-14	9.3 (21)
167	3	24	3032	0	674	qwrqwr	2011-01-18	9.9 (15)
156	2	52	3004	3	391	anddros	2009-04-17	9.1 (30)
144	4	47	2996	4	950	pvv	2008-01-01	7.4 (30)
187	3	26	2965	0	978	=Maxim=	2011-12-31	8.8 (21)
232	3	6	2940	0	513	al29	2018-08-20	10.0 (5)
100	4	263	2919	9	650	qwrqwr	2010-04-27	9.4 (133)
102	4	192	2588	8	933	GriGrim	2011-07-16	9.5 (91)
221	2	17	2539	1	1023	Baser	2016-11-05	8.9 (10)
223	2	13	2357	0	641	Baser	2016-11-12	9.9 (8)
141	4	81	2335	11	977	vlksm	2006-10-29	9.0 (36)
179	3	17	2329	0	844	pegoopik	2011-09-17	9.2 (12)
210	2	15	2132	0	483	_dimon_	2014-02-07	10.0 (11)
101	4	226	2125	19	1096	pegoopik	2010-11-20	9.3 (121)
120	4	112	2008	2	239	pegoopik	2014-02-14	9.0 (56)
145	3	72	2007	1	859	pvv	2008-01-07	8.7 (34)
184	2	26	1953	1	432	Baser	2011-11-26	8.9 (20)
227	3	10	1948	1	2142	mcrain	2017-12-08	7.3 (6)
164	2	37	1943	2	1622	anddros	2010-04-26	9.7 (22)
98	4	598	1912	44	538	ZrenBy	2003-09-01	8.2 (138)
148	2	68	1910	7	894	vlksm	2008-09-06	9.3 (36)
205	2	16	1877	0	529	qwrqwr	2013-11-22	8.9 (10)
72	4	1038	1868	151	608	paparome	2005-12-03	9.2 (285)
193	2	22	1798	0	522	Baser	2012-07-06	8.3 (15)
150	4	38	1780	6	909	@Nikotin	2008-11-09	8.6 (22)
182	3	23	1717	0	1377	Baser	2011-10-29	8.1 (17)
222	2	15	1664	0	1475	pegoopik	2016-12-23	9.8 (9)
89	3	428	1637	31	870	_Bkmz_	2008-06-21	7.9 (163)
165	2	31	1631	3	1600	vlksm	2010-03-18	9.8 (19)
137	4	197	1618	25	616	Cyrilus	2005-03-06	9.2 (70)
183	2	30	1611	2	518	GriGrim	2011-11-12	9.1 (15)
146	3	63	1606	3	949	paparome	2008-01-22	9.7 (34)
87	4	651	1604	89	459	Roman Golubin	2006-07-14	9.3 (184)
200	3	19	1586	0	1129	qwrqwr	2013-10-05	9.3 (13)
175	3	30	1548	1	2151	pegoopik	2011-04-28	8.5 (22)
228	1	19	1540	1	1419	qwrqwr	2018-01-12	10.0 (11)
121	3	414	1529	4	804	ZrenBy	2004-02-26	7.6 (102)
169	3	32	1519	0	1559	Valdaj	2010-09-02	8.5 (22)
136	3	120	1511	5	618	Ozzy	2011-05-12	7.5 (53)
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)
135	3	71	1483	2	854	qwrqwr	2013-04-19	9.1 (38)
219	2	17	1482	0	486	pegoopik	2016-04-08	9.9 (9)
132	3	116	1453	4	2500	risp	2010-01-25	7.5 (58)
198	2	23	1444	1	332	Angellore	2013-09-13	9.4 (16)
152	3	49	1420	4	1301	vlksm	2009-01-05	9.6 (28)
233	1	17	1394	0	2321	pegoopik	2019-03-08	10.0 (9)
180	3	32	1375	0	274	qwrqwr	2011-09-16	9.6 (24)
199	3	20	1350	0	1448	Baser	2013-08-17	8.4 (14)
76	3	475	1348	14	949	silver	2010-01-23	8.8 (190)
213	2	26	1346	0	369	qwrqwr	2014-10-17	9.6 (15)
123	3	253	1334	38	1254	Ozzy	2009-08-22	9.0 (119)
158	3	38	1330	0	1174	Ozzy	2010-04-09	8.9 (23)
68	3	320	1328	26	608	pegoopik	2014-08-01	8.1 (123)
215	2	23	1326	0	331	pegoopik	2015-03-06	9.3 (13)
85	3	382	1324	20	1397	Ozzy	2009-10-10	8.5 (150)
212	3	16	1319	0	585	Baser	2014-10-14	8.9 (10)
168	2	43	1310	2	455	qwrqwr	2010-08-27	9.5 (25)
82	3	404	1279	12	1780	_Virt_	2010-04-27	8.2 (152)
106	3	293	1271	5	647	vlksm	2008-11-27	8.8 (128)
207	3	17	1255	0	486	pegoopik	2016-01-15	10.0 (9)
69	2	198	1246	8	210	Gosha	2017-12-15	9.0 (68)
226	3	11	1235	1	2054	pegoopik	2017-10-14	9.3 (6)
186	1	37	1215	0	1447	Ozzy	2011-12-30	9.2 (24)
77	2	327	1211	32	1053	selber	2015-07-10	8.7 (137)
173	1	52	1172	3	945	Ozzy	2011-01-13	9.3 (28)
65	3	746	1152	51	671	Ozzy	2010-01-29	7.7 (263)
96	3	428	1152	81	572	anddros	2008-11-22	8.8 (170)
84	3	433	1147	17	815	Ozzy	2009-12-26	8.3 (161)
57	2	209	1106	15	537	Kursist	2020-10-10	8.4 (62)
93	3	182	1086	5	492	qwrqwr	2014-03-14	9.3 (76)
134	3	181	1041	4	821	pvv	2008-01-22	8.6 (73)
140	2	83	925	2	578	_Bkmz_	2010-01-30	8.9 (42)
32	3	82	924	18	476	blr_Oliver	2023-07-08	9.2 (29)
37	3	822	868	25	576	qwrqwr	2013-02-22	8.0 (273)
71	3	563	805	24	941	anddros	2009-12-26	8.4 (198)
125	3	379	735	3	526	dimzv	2004-02-29	8.7 (95)
185	1	44	688	3	782	=Maxim=	2011-11-25	7.9 (26)
195	3	27	658	0	722	Dmitrij Grinkevich	2013-04-20	9.1 (16)
126	2	191	627	12	944	$erges	2008-09-07	8.6 (93)
110	3	441	626	12	942	Snowbear	2006-03-14	8.9 (122)
251	4	68	594	3	850	paparome	2006-10-01	8.0 (29)
162	2	59	592	1	1067	Ozzy	2009-12-26	9.3 (34)
307	2	19	553	0	1095	Baser	2017-06-29	8.5 (11)
174	1	56	535	0	1084	qwrqwr	2011-02-25	9.3 (32)
130	2	125	534	0	700	anddros	2010-05-22	8.9 (62)
58	3	672	532	13	397	qwrqwr	2013-03-01	8.2 (233)
107	2	415	515	10	688	Fiolent	2004-02-26	8.0 (106)
202	2	29	504	1	557	qwrqwr	2013-11-01	9.1 (16)
99	3	209	471	9	956	Dmitrij Grinkevich	2012-05-05	8.2 (86)
66	3	700	461	54	392	anddros	2009-12-26	8.5 (259)
254	1	45	420	1	1383	Baser	2011-09-02	8.8 (27)
177	1	53	390	0	935	pegoopik	2011-07-17	8.5 (26)
64	3	641	380	50	506	qwrqwr	2010-05-13	8.1 (201)
142	2	117	379	1	944	paparome	2007-03-24	9.0 (49)
166	1	63	375	1	449	anddros	2010-07-26	9.6 (32)
127	2	66	373	2	985	GriGrim	2014-12-21	8.1 (30)
108	3	289	370	5	521	crescent	2011-03-23	8.9 (117)
80	2	359	360	11	453	qwrqwr	2011-10-21	9.0 (144)
115	2	89	360	1	736	selber	2016-05-28	8.9 (39)
23	3	1623	353	125	307	Palkin	2007-03-29	8.4 (391)
170	2	56	332	1	320	qwrqwr	2010-10-24	9.1 (29)
5	1	168	329	136	224	Serge I	2023-06-18	8.6 (54)
209	1	33	319	1	735	Baser	2013-12-30	8.0 (15)
92	2	572	303	9	405	paparome	2006-07-26	8.5 (128)
139	2	128	295	2	907	Snowbear	2006-09-09	8.3 (46)
111	2	463	271	3	545	Fiolent	2005-01-19	8.3 (105)
36	3	1091	269	23	786	risp	2011-05-06	8.0 (328)
12	1	516	267	47	348	Serge I	2019-04-12	7.0 (121)
47	3	1007	255	14	554	qwrqwr	2010-11-20	8.2 (307)
29	2	1143	254	40	799	GiBis	2011-09-17	7.5 (351)
41	3	1175	253	18	253	qwrqwr	2010-04-26	8.1 (371)
45	2	504	250	15	473	dumkan	2016-04-03	8.1 (137)
54	2	1396	248	45	796	Ozzy	2008-09-06	8.2 (482)
262	2	14	243	1	740	selber	2019-06-21	7.0 (7)
204	1	35	241	1	366	anddros	2013-11-19	8.5 (18)
67	2	610	238	18	729	Ozzy	2010-04-27	8.3 (214)
60	3	2115	233	119	313	Serge I	2005-03-05	7.9 (350)
118	2	435	231	1	206	Fiolent	2004-01-05	8.1 (93)
133	2	97	228	0	1614	pickman	2011-07-01	8.3 (49)
91	2	239	222	1	642	smog	2012-05-26	9.1 (96)
105	2	150	211	0	610	Baser	2013-09-20	8.6 (58)
34	2	1238	208	26	765	qwrqwr	2010-09-24	7.9 (371)
122	1	142	207	2	725	Dmitrij Grinkevich	2012-09-14	5.8 (59)
129	2	280	202	7	658	DimaN	2004-03-01	7.5 (62)
43	2	582	200	3	597	qwrqwr	2015-04-24	8.4 (182)
95	1	111	195	2	350	qwrqwr	2017-12-01	9.4 (44)
75	2	418	185	4	644	qwrqwr	2011-07-22	7.5 (153)
40	1	366	184	10	398	Serge I	2018-09-07	7.0 (96)
260	2	53	183	0	999	qwrqwr	2012-02-03	7.7 (37)
62	2	763	179	11	576	Dmitrij Grinkevich	2012-02-11	8.1 (238)
20	2	1566	179	33	327	VIG	2003-09-01	8.0 (353)
86	2	364	177	0	433	Ozzy	2010-03-05	8.6 (123)
38	2	1090	169	26	302	ZrenBy	2003-09-01	7.5 (221)
261	1	35	169	1	1495	Fomichev	2013-12-07	7.0 (19)
59	2	968	168	7	203	VIG	2003-12-22	8.3 (216)
49	2	1236	166	23	891	anddros	2009-06-05	7.9 (386)
61	2	1018	161	5	772	risp	2009-12-26	8.5 (334)
124	2	385	160	3	455	DimaN	2004-02-26	8.2 (91)
304	2	25	151	0	1132	aks_nsk	2016-02-05	9.4 (16)
131	2	98	144	1	498	GriGrim	2012-05-25	8.6 (46)
74	2	688	143	8	855	vlksm	2008-06-21	8.3 (212)
7	1	340	142	108	513	Baser	2021-02-27	8.0 (78)
203	1	42	139	1	932	=Maxim=	2013-10-05	9.4 (25)
16	2	991	132	60	336	qwrqwr	2014-07-18	7.5 (266)
109	2	504	132	1	671	VIG	2003-12-23	8.0 (101)
201	2	39	127	0	749	Baser	2013-09-21	8.8 (24)
303	2	9	127	0	687	selber	2023-12-27	9.0 (5)
39	2	1433	126	24	256	Serge I	2003-08-28	7.5 (293)
55	2	621	123	6	339	VIG	2005-06-26	7.8 (127)
78	2	436	122	5	451	_ORA_	2010-04-27	7.5 (135)
83	2	553	120	5	798	lepton	2006-09-29	8.6 (157)
81	2	614	118	12	707	$erges	2008-05-10	8.3 (175)
51	1	616	118	14	416	Fiolent	2004-06-23	8.3 (164)
94	2	270	111	0	773	pickman	2011-04-27	8.3 (97)
35	3	641	110	13	695	Baser	2015-09-18	8.7 (187)
235	2	8	110	0	665	Kursist	2021-07-10	9.6 (5)
33	2	1320	109	26	364	DimaN	2004-03-01	7.7 (358)
104	1	151	108	0	571	pegoopik	2013-07-19	8.4 (64)
236	1	12	106	0	467	Baser	2021-07-24	9.7 (9)
79	1	986	103	14	403	Serge I	2003-06-05	7.8 (162)
197	1	44	102	0	518	pegoopik	2013-06-10	8.9 (20)
128	1	235	101	4	829	inkerman	2007-09-14	8.4 (76)
90	1	251	100	1	499	Dmitrij Grinkevich	2012-03-03	8.0 (89)
52	1	555	99	3	268	Serge I	2015-01-10	8.6 (159)
44	2	793	99	8	273	Serge I	2011-11-25	7.9 (244)
17	2	1726	98	27	122	VIG	2003-04-29	8.2 (337)
73	1	478	96	3	367	Ruslan1707	2010-11-02	7.5 (158)
46	2	1251	95	127	340	Serge I	2009-08-12	6.9 (333)
70	1	698	94	3	334	Serge I	2009-04-17	7.9 (228)
6	2	2204	93	127	281	Serge I	2005-05-07	8.0 (393)
113	1	145	92	0	497	smog	2013-03-29	8.6 (61)
305	1	26	91	1	160	Baser	2017-01-06	9.1 (15)
103	1	151	86	1	850	Baser	2013-10-05	7.5 (61)
114	1	461	83	4	298	Serge I	2003-12-24	8.5 (100)
256	1	40	82	1	436	anddros	2013-11-08	9.0 (21)
238	2	6	81	0	1143	Baser	2022-05-13	8.3 (4)
24	2	1692	79	6	685	Aaz	2004-02-26	7.0 (469)
26	1	1546	79	28	289	VIG	2003-12-22	7.7 (368)
25	2	1300	75	31	232	DimaN	2004-06-22	7.2 (337)
9	2	1506	72	31	498	vasia armor	2010-05-21	8.0 (433)
10	1	840	72	49	179	Serge I	2017-01-20	8.1 (231)
50	1	599	71	17	421	mslava	2003-12-23	7.2 (121)
28	1	1277	70	10	283	ZrenBy	2003-09-01	7.6 (242)
8	2	1602	67	94	600	Serge I	2008-06-21	7.7 (396)
21	1	1277	63	9	709	paparome	2006-03-14	8.0 (289)
97	1	384	63	3	231	dimzv	2004-03-01	7.6 (86)
112	1	54	62	2	393	Gosha	2020-06-03	8.7 (25)
18	1	1705	56	12	157	ZrenBy	2003-09-01	7.7 (371)
42	1	1670	55	15	249	Serge I	2003-06-05	7.7 (333)
117	1	438	52	0	193	Fiolent	2003-12-26	7.7 (89)
192	2	49	52	0	709	Baser	2012-03-03	9.2 (26)
27	1	1342	51	8	376	Fiolent	2004-02-26	7.4 (309)
30	1	1817	50	3	205	Serge I	2003-08-28	7.9 (403)
48	1	1213	50	6	252	Serge I	2009-06-22	7.4 (320)
56	1	1107	47	3	565	Fiolent	2004-06-22	8.0 (289)
63	1	1386	47	5	190	VIG	2003-06-05	7.6 (254)
19	1	2068	47	23	269	Serge I	2004-06-23	7.5 (423)
22	1	1691	47	12	270	ZrenBy	2003-09-01	7.4 (388)
14	1	2532	47	38	116	Serge I	2003-04-08	7.6 (447)
302	0	38	45	0	510	pegoopik	2012-07-27	7.8 (12)
31	1	1110	43	6	349	Fiolent	2004-06-22	7.9 (271)
13	1	1819	40	22	194	ZrenBy	2003-09-01	7.6 (421)
88	2	53	39	1	293	Serge I	2021-10-15	9.2 (18)
53	1	1520	37	25	234	DimaN	2004-03-01	7.7 (393)
15	1	1297	36	8	287	Dmitrij Grinkevich	2012-04-21	7.6 (336)
11	1	2006	35	15	130	ZrenBy	2003-09-01	7.6 (448)
306	1	14	28	1	363	Baser	2022-04-29	8.3 (8)
258	3	25	13	0	1070	Baser	2014-09-19	7.6 (10)
301	0	45	8	0	55	pegoopik	2012-03-23	8.7 (22)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References