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

September 22, 06:57 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
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	28	14593	2	1213	$erges	2010-08-06	9.7 (19)
157	3	24	12925	2	960	anddros	2009-06-05	9.6 (15)
163	3	19	11408	0	1640	Ozzy	2010-01-08	9.6 (14)
143	5	46	11333	14	946	inkerman	2007-10-07	8.8 (30)
214	4	11	10103	0	433	pegoopik	2015-05-30	10.0 (7)
155	3	27	9893	2	761	vlksm	2009-04-17	9.9 (18)
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	1	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	7	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	146	6228	33	949	Cyrilus	2005-12-09	9.1 (65)
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)
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)
154	4	26	4200	3	848	anddros	2009-03-18	9.9 (17)
252	2	35	3918	3	308	Ozzy	2009-06-14	8.4 (23)
149	3	35	3891	3	506	$erges	2008-09-08	9.2 (21)
171	3	19	3682	1	1670	Ozzy	2010-12-05	9.3 (15)
218	4	13	3491	2	1500	al29	2016-04-04	9.6 (8)
116	5	248	3479	20	469	$erges	2008-12-13	9.4 (120)
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)
188	3	17	3191	1	733	qwrqwr	2012-02-04	9.8 (12)
151	3	35	3190	4	1096	anddros	2008-12-30	9.0 (20)
119	5	110	3102	4	703	Velmont	2014-03-07	9.6 (59)
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)
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)
144	4	46	2928	4	950	pvv	2008-01-01	7.3 (29)
100	4	255	2919	11	650	qwrqwr	2010-04-27	9.4 (129)
153	3	37	2779	4	1539	Ozzy	2009-02-14	9.5 (20)
102	4	186	2598	8	933	GriGrim	2011-07-16	9.5 (89)
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)
179	3	17	2329	0	844	pegoopik	2011-09-17	9.2 (12)
141	4	80	2225	10	977	vlksm	2006-10-29	9.0 (36)
210	2	15	2132	0	483	_dimon_	2014-02-07	10.0 (11)
101	4	220	2125	16	1096	pegoopik	2010-11-20	9.4 (118)
120	4	107	2024	2	239	pegoopik	2014-02-14	9.0 (53)
145	3	71	2007	1	859	pvv	2008-01-07	8.6 (33)
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	1	1622	anddros	2010-04-26	9.7 (22)
148	2	67	1924	7	894	vlksm	2008-09-06	9.3 (35)
98	4	591	1912	44	538	ZrenBy	2003-09-01	8.2 (135)
72	4	1028	1879	150	608	paparome	2005-12-03	9.2 (280)
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)
150	4	37	1780	5	909	@Nikotin	2008-11-09	8.6 (21)
182	3	23	1717	0	1377	Baser	2011-10-29	8.1 (17)
87	4	645	1663	89	459	Roman Golubin	2006-07-14	9.3 (183)
89	3	422	1658	31	870	_Bkmz_	2008-06-21	7.9 (161)
183	2	30	1611	2	518	GriGrim	2011-11-12	9.1 (15)
137	4	191	1607	25	616	Cyrilus	2005-03-06	9.2 (67)
146	3	62	1606	3	949	paparome	2008-01-22	9.7 (34)
200	3	19	1586	0	1129	qwrqwr	2013-10-05	9.3 (13)
222	2	14	1583	1	1475	pegoopik	2016-12-23	9.8 (9)
175	3	30	1548	1	2151	pegoopik	2011-04-28	8.5 (22)
165	2	30	1544	3	1600	vlksm	2010-03-18	9.9 (18)
228	1	19	1540	1	1419	qwrqwr	2018-01-12	10.0 (11)
121	3	409	1529	4	804	ZrenBy	2004-02-26	7.7 (100)
169	3	32	1519	0	1559	Valdaj	2010-09-02	8.5 (22)
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	17	1482	0	486	pegoopik	2016-04-08	9.9 (9)
136	3	114	1480	6	618	Ozzy	2011-05-12	7.5 (50)
132	3	111	1453	4	2500	risp	2010-01-25	7.7 (55)
198	2	23	1444	1	332	Angellore	2013-09-13	9.4 (16)
152	3	47	1420	4	1301	vlksm	2009-01-05	9.7 (27)
180	3	32	1375	0	274	qwrqwr	2011-09-16	9.6 (24)
76	3	463	1373	16	949	silver	2010-01-23	8.8 (186)
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)
123	3	249	1343	38	1254	Ozzy	2009-08-22	9.0 (117)
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)
85	3	375	1326	20	1397	Ozzy	2009-10-10	8.6 (147)
135	3	66	1323	1	854	qwrqwr	2013-04-19	8.9 (34)
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	397	1289	11	1780	_Virt_	2010-04-27	8.2 (148)
106	3	285	1271	6	647	vlksm	2008-11-27	8.8 (125)
68	3	305	1269	26	608	pegoopik	2014-08-01	8.1 (120)
207	3	17	1255	0	486	pegoopik	2016-01-15	10.0 (9)
69	2	182	1246	8	210	Gosha	2017-12-15	9.1 (64)
186	1	37	1215	0	1447	Ozzy	2011-12-30	9.2 (24)
96	3	421	1198	81	572	anddros	2008-11-22	8.8 (169)
77	2	316	1194	33	1053	selber	2015-07-10	8.7 (133)
173	1	52	1172	3	945	Ozzy	2011-01-13	9.3 (28)
65	3	732	1165	50	671	Ozzy	2010-01-29	7.8 (259)
84	3	426	1154	16	815	Ozzy	2009-12-26	8.4 (158)
93	3	176	1122	5	492	qwrqwr	2014-03-14	9.3 (75)
57	2	177	1061	16	537	Kursist	2020-10-10	8.3 (54)
134	3	176	1003	4	821	pvv	2008-01-22	8.5 (71)
233	1	16	930	1	2321	pegoopik	2019-03-08	10.0 (9)
37	3	794	868	25	576	qwrqwr	2013-02-22	8.0 (269)
32	3	29	799	5	476	blr_Oliver	2023-07-08	9.6 (16)
71	3	552	797	22	941	anddros	2009-12-26	8.4 (195)
125	3	375	735	3	526	dimzv	2004-02-29	8.7 (93)
140	2	82	720	2	578	_Bkmz_	2010-01-30	8.9 (41)
185	1	44	688	3	782	=Maxim=	2011-11-25	7.9 (26)
195	3	26	658	0	722	Dmitrij Grinkevich	2013-04-20	9.1 (15)
110	3	435	658	11	942	Snowbear	2006-03-14	8.9 (118)
226	3	10	652	2	2054	pegoopik	2017-10-14	9.3 (6)
126	2	186	601	12	944	$erges	2008-09-07	8.6 (91)
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	647	578	13	397	qwrqwr	2013-03-01	8.2 (224)
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	120	534	0	700	anddros	2010-05-22	8.9 (59)
99	3	203	510	8	956	Dmitrij Grinkevich	2012-05-05	8.2 (85)
202	2	29	504	0	557	qwrqwr	2013-11-01	9.1 (16)
107	2	408	465	9	688	Fiolent	2004-02-26	8.1 (102)
66	3	685	463	54	392	anddros	2009-12-26	8.5 (256)
64	3	623	425	49	506	qwrqwr	2010-05-13	8.1 (196)
254	1	45	420	1	1383	Baser	2011-09-02	8.8 (27)
127	2	61	406	2	985	GriGrim	2014-12-21	7.9 (27)
177	1	53	390	0	935	pegoopik	2011-07-17	8.5 (26)
142	2	115	379	1	944	paparome	2007-03-24	9.0 (48)
166	1	61	375	1	449	anddros	2010-07-26	9.5 (31)
108	3	283	370	5	521	crescent	2011-03-23	8.9 (115)
80	2	350	364	10	453	qwrqwr	2011-10-21	9.0 (141)
115	2	83	360	1	736	selber	2016-05-28	9.1 (36)
23	3	1590	357	125	307	Palkin	2007-03-29	8.4 (387)
170	2	55	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	566	303	9	405	paparome	2006-07-26	8.6 (127)
139	2	126	295	2	907	Snowbear	2006-09-09	8.3 (44)
45	2	477	285	15	473	dumkan	2016-04-03	8.0 (133)
36	3	1062	272	23	786	risp	2011-05-06	8.0 (322)
5	1	54	272	26	206	Serge I	2023-06-18	8.5 (26)
111	2	457	271	3	545	Fiolent	2005-01-19	8.3 (103)
47	3	981	262	14	554	qwrqwr	2010-11-20	8.1 (301)
41	3	1148	257	18	253	qwrqwr	2010-04-26	8.1 (364)
29	2	1113	256	39	799	GiBis	2011-09-17	7.5 (346)
54	2	1371	247	45	796	Ozzy	2008-09-06	8.2 (475)
12	1	466	244	49	348	Serge I	2019-04-12	7.2 (113)
262	2	14	243	0	740	selber	2019-06-21	7.0 (7)
60	3	2090	240	120	313	Serge I	2005-03-05	7.9 (343)
67	2	596	238	17	729	Ozzy	2010-04-27	8.3 (211)
204	1	34	232	1	366	anddros	2013-11-19	8.7 (17)
118	2	430	228	1	206	Fiolent	2004-01-05	8.2 (91)
133	2	92	228	0	1614	pickman	2011-07-01	8.2 (47)
91	2	233	218	1	642	smog	2012-05-26	9.1 (95)
105	2	143	211	0	610	Baser	2013-09-20	8.6 (56)
34	2	1208	208	28	765	qwrqwr	2010-09-24	7.9 (365)
129	2	275	202	7	658	DimaN	2004-03-01	7.5 (59)
122	1	138	197	2	725	Dmitrij Grinkevich	2012-09-14	5.9 (56)
43	2	556	194	3	597	qwrqwr	2015-04-24	8.4 (177)
95	1	103	192	3	350	qwrqwr	2017-12-01	9.4 (43)
75	2	408	186	4	644	qwrqwr	2011-07-22	7.5 (149)
260	2	52	183	0	999	qwrqwr	2012-02-03	7.7 (35)
238	2	5	180	0	1143	Baser	2022-05-13	8.0 (3)
40	1	333	180	11	398	Serge I	2018-09-07	7.1 (89)
20	2	1533	179	31	327	VIG	2003-09-01	8.0 (349)
62	2	739	178	10	576	Dmitrij Grinkevich	2012-02-11	8.0 (232)
131	2	93	177	1	498	GriGrim	2012-05-25	8.6 (43)
86	2	358	175	0	433	Ozzy	2010-03-05	8.7 (122)
49	2	1212	169	22	891	anddros	2009-06-05	7.9 (381)
261	1	35	169	1	1495	Fomichev	2013-12-07	7.0 (19)
59	2	944	166	6	203	VIG	2003-12-22	8.3 (209)
38	2	1063	166	25	302	ZrenBy	2003-09-01	7.5 (217)
61	2	993	164	5	772	risp	2009-12-26	8.5 (327)
124	2	381	160	3	455	DimaN	2004-02-26	8.3 (89)
203	1	40	160	1	932	=Maxim=	2013-10-05	9.4 (23)
304	2	24	151	0	1132	aks_nsk	2016-02-05	9.3 (15)
74	2	678	143	8	855	vlksm	2008-06-21	8.3 (209)
7	1	274	142	107	513	Baser	2021-02-27	7.9 (69)
55	2	593	137	6	339	VIG	2005-06-26	7.7 (120)
16	2	952	136	60	336	qwrqwr	2014-07-18	7.5 (262)
109	2	497	132	1	671	VIG	2003-12-23	8.0 (99)
201	2	38	127	0	749	Baser	2013-09-21	8.7 (23)
39	2	1406	125	24	256	Serge I	2003-08-28	7.5 (287)
83	2	546	120	5	798	lepton	2006-09-29	8.5 (154)
78	2	426	119	5	451	_ORA_	2010-04-27	7.5 (133)
81	2	605	118	12	707	$erges	2008-05-10	8.3 (172)
235	2	7	117	0	665	Kursist	2021-07-10	9.5 (4)
51	1	591	116	14	416	Fiolent	2004-06-23	8.3 (159)
94	2	264	114	0	773	pickman	2011-04-27	8.3 (96)
35	3	611	109	13	695	Baser	2015-09-18	8.7 (179)
33	2	1292	108	27	364	DimaN	2004-03-01	7.6 (353)
197	1	43	107	0	518	pegoopik	2013-06-10	8.8 (19)
236	1	10	106	0	467	Baser	2021-07-24	9.6 (7)
128	1	230	104	4	829	inkerman	2007-09-14	8.4 (74)
52	1	530	103	3	268	Serge I	2015-01-10	8.6 (154)
79	1	976	103	14	403	Serge I	2003-06-05	7.8 (159)
90	1	245	101	1	499	Dmitrij Grinkevich	2012-03-03	8.0 (88)
104	1	144	101	0	571	pegoopik	2013-07-19	8.3 (61)
305	1	25	101	0	160	Baser	2017-01-06	9.0 (14)
44	2	767	99	8	273	Serge I	2011-11-25	7.9 (240)
73	1	468	97	3	367	Ruslan1707	2010-11-02	7.5 (155)
17	2	1689	97	25	122	VIG	2003-04-29	8.2 (330)
46	2	1225	96	127	340	Serge I	2009-08-12	6.8 (327)
70	1	684	95	3	334	Serge I	2009-04-17	7.9 (224)
6	2	2148	94	127	281	Serge I	2005-05-07	8.0 (383)
113	1	139	91	0	497	smog	2013-03-29	8.6 (59)
103	1	144	85	1	850	Baser	2013-10-05	7.5 (59)
114	1	455	83	4	298	Serge I	2003-12-24	8.4 (98)
256	1	39	82	1	436	anddros	2013-11-08	8.9 (20)
24	2	1658	79	6	685	Aaz	2004-02-26	7.0 (464)
26	1	1516	78	26	289	VIG	2003-12-22	7.7 (364)
25	2	1267	75	30	232	DimaN	2004-06-22	7.1 (330)
10	1	794	74	49	179	Serge I	2017-01-20	8.0 (222)
9	2	1462	72	31	498	vasia armor	2010-05-21	8.0 (427)
28	1	1247	69	11	283	ZrenBy	2003-09-01	7.5 (238)
8	2	1556	66	95	600	Serge I	2008-06-21	7.7 (388)
21	1	1244	63	9	709	paparome	2006-03-14	8.1 (282)
97	1	377	63	3	231	dimzv	2004-03-01	7.6 (85)
112	1	46	59	2	393	Gosha	2020-06-03	8.9 (22)
50	1	565	58	18	421	mslava	2003-12-23	7.3 (111)
42	1	1644	55	14	249	Serge I	2003-06-05	7.7 (327)
18	1	1670	55	10	157	ZrenBy	2003-09-01	7.7 (368)
117	1	432	53	0	193	Fiolent	2003-12-26	7.6 (87)
27	1	1313	52	8	376	Fiolent	2004-02-26	7.4 (304)
192	2	48	52	0	709	Baser	2012-03-03	9.2 (25)
30	1	1787	50	3	205	Serge I	2003-08-28	7.9 (396)
48	1	1187	50	6	252	Serge I	2009-06-22	7.4 (315)
56	1	1082	47	3	565	Fiolent	2004-06-22	8.0 (285)
19	1	2033	47	23	269	Serge I	2004-06-23	7.5 (420)
22	1	1658	47	12	270	ZrenBy	2003-09-01	7.3 (383)
14	1	2494	47	37	116	Serge I	2003-04-08	7.6 (441)
63	1	1362	46	5	190	VIG	2003-06-05	7.6 (247)
302	0	37	45	0	510	pegoopik	2012-07-27	7.6 (11)
31	1	1080	44	6	349	Fiolent	2004-06-22	7.9 (266)
13	1	1777	40	21	194	ZrenBy	2003-09-01	7.5 (415)
306	1	9	39	0	363	Baser	2022-04-29	7.4 (5)
53	1	1495	38	25	234	DimaN	2004-03-01	7.6 (387)
88	2	42	37	1	293	Serge I	2021-10-15	9.2 (16)
11	1	1963	35	15	130	ZrenBy	2003-09-01	7.5 (444)
15	1	1258	35	8	287	Dmitrij Grinkevich	2012-04-21	7.6 (333)
258	3	25	13	0	1070	Baser	2014-09-19	7.6 (10)
301	0	44	8	0	55	pegoopik	2012-03-23	8.7 (21)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References