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

August 03, 17:23 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

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

Звоните 7(495) 660-92-90 пластика груди
lantanclinic.ru
Vzp
vzp
petrocontrol.ru
Сайт гидра
сайт гидра
sitegidra.com

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)
163	3	19	11408	0	1640	Ozzy	2010-01-08	9.6 (14)
143	5	44	11333	14	946	inkerman	2007-10-07	8.8 (29)
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	3	7476	0	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	144	6385	33	949	Cyrilus	2005-12-09	9.2 (64)
161	3	21	6370	2	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)
225	2	9	6053	0	737	pegoopik	2017-07-15	9.8 (6)
211	2	13	5791	1	588	Baser	2014-06-30	9.8 (9)
255	4	14	5666	3	793	vlksm	2012-02-14	9.8 (9)
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	26	4731	0	961	Ozzy	2009-08-07	9.6 (17)
159	3	17	4480	0	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	33	3909	2	506	$erges	2008-09-08	9.2 (21)
172	3	21	3717	0	1719	Ozzy	2011-03-11	9.7 (15)
171	3	19	3682	1	1670	Ozzy	2010-12-05	9.3 (15)
116	5	233	3494	19	469	$erges	2008-12-13	9.3 (107)
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)
119	5	94	3203	5	703	Velmont	2014-03-07	9.7 (49)
188	3	17	3191	1	733	qwrqwr	2012-02-04	9.8 (12)
151	3	32	3152	5	1096	anddros	2008-12-30	8.9 (19)
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	25	2965	0	978	=Maxim=	2011-12-31	8.8 (20)
144	4	44	2928	4	950	pvv	2008-01-01	7.3 (27)
100	4	233	2919	10	650	qwrqwr	2010-04-27	9.4 (114)
102	4	169	2835	6	933	GriGrim	2011-07-16	9.4 (77)
153	3	35	2779	5	1539	Ozzy	2009-02-14	9.5 (20)
120	4	93	2578	1	239	pegoopik	2014-02-14	8.9 (44)
221	2	13	2539	0	1023	Baser	2016-11-05	8.6 (8)
190	4	16	2521	1	717	vlksm	2012-03-17	8.8 (13)
141	4	78	2335	9	977	vlksm	2006-10-29	9.0 (35)
179	3	17	2329	0	844	pegoopik	2011-09-17	9.2 (12)
178	3	22	2268	1	1680	Baser	2011-08-13	9.1 (15)
101	4	201	2145	14	1096	pegoopik	2010-11-20	9.4 (106)
227	3	9	2137	1	2142	mcrain	2017-12-08	7.0 (5)
210	2	14	2132	0	483	_dimon_	2014-02-07	10.0 (11)
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)
72	4	993	1941	151	608	paparome	2005-12-03	9.2 (262)
148	2	65	1924	7	894	vlksm	2008-09-06	9.3 (35)
98	4	568	1897	46	538	ZrenBy	2003-09-01	8.2 (123)
205	2	15	1877	0	529	qwrqwr	2013-11-22	8.9 (10)
193	2	21	1798	0	522	Baser	2012-07-06	8.3 (15)
87	4	619	1724	89	459	Roman Golubin	2006-07-14	9.3 (170)
89	3	399	1686	29	870	_Bkmz_	2008-06-21	7.8 (147)
150	4	35	1652	4	909	@Nikotin	2008-11-09	8.5 (20)
137	4	189	1619	24	616	Cyrilus	2005-03-06	9.2 (66)
183	2	30	1611	2	518	GriGrim	2011-11-12	9.1 (15)
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)
222	2	11	1583	1	1475	pegoopik	2016-12-23	9.8 (8)
182	3	22	1566	0	1377	Baser	2011-10-29	8.1 (17)
219	2	15	1565	0	486	pegoopik	2016-04-08	9.9 (8)
175	3	29	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	395	1529	4	804	ZrenBy	2004-02-26	7.8 (91)
169	3	29	1519	0	1559	Valdaj	2010-09-02	8.4 (21)
196	3	25	1494	0	661	qwrqwr	2013-05-17	9.4 (15)
136	3	111	1492	5	618	Ozzy	2011-05-12	7.3 (47)
176	3	31	1484	0	385	qwrqwr	2011-05-20	9.5 (21)
200	3	18	1463	0	1129	qwrqwr	2013-10-05	9.3 (12)
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	233	1405	39	1254	Ozzy	2009-08-22	9.0 (107)
233	1	13	1394	1	2321	pegoopik	2019-03-08	10.0 (7)
180	3	32	1375	0	274	qwrqwr	2011-09-16	9.6 (24)
76	3	428	1371	16	949	silver	2010-01-23	8.8 (169)
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)
77	2	283	1327	31	1053	selber	2015-07-10	8.7 (117)
215	2	23	1326	0	331	pegoopik	2015-03-06	9.3 (13)
135	3	62	1323	1	854	qwrqwr	2013-04-19	8.9 (33)
96	3	400	1322	81	572	anddros	2008-11-22	8.8 (156)
106	3	268	1322	6	647	vlksm	2008-11-27	8.7 (112)
212	3	16	1319	0	585	Baser	2014-10-14	8.9 (10)
69	2	136	1284	7	210	Gosha	2017-12-15	9.1 (47)
82	3	367	1279	13	1780	_Virt_	2010-04-27	8.2 (134)
85	3	347	1268	18	1397	Ozzy	2009-10-10	8.5 (134)
207	3	15	1255	1	486	pegoopik	2016-01-15	10.0 (8)
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)
68	3	260	1207	21	608	pegoopik	2014-08-01	8.0 (102)
65	3	667	1178	47	671	Ozzy	2010-01-29	7.7 (240)
173	1	52	1172	2	945	Ozzy	2011-01-13	9.3 (28)
168	2	42	1159	2	455	qwrqwr	2010-08-27	9.5 (24)
84	3	395	1154	18	815	Ozzy	2009-12-26	8.4 (144)
93	3	154	1134	5	492	qwrqwr	2014-03-14	9.3 (64)
134	3	172	1041	4	821	pvv	2008-01-22	8.6 (67)
37	3	675	950	27	673	qwrqwr	2013-02-22	8.0 (238)
140	2	80	925	2	578	_Bkmz_	2010-01-30	8.9 (40)
71	3	516	805	19	941	anddros	2009-12-26	8.4 (178)
125	3	359	765	3	526	dimzv	2004-02-29	8.7 (84)
185	1	43	688	3	782	=Maxim=	2011-11-25	7.9 (25)
110	3	418	673	11	942	Snowbear	2006-03-14	8.8 (106)
195	3	26	658	0	722	Dmitrij Grinkevich	2013-04-20	9.1 (15)
126	2	179	633	11	944	$erges	2008-09-07	8.6 (87)
58	3	547	606	12	440	qwrqwr	2013-03-01	8.2 (199)
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)
307	2	19	553	0	1095	Baser	2017-06-29	8.5 (11)
45	2	362	544	16	509	dumkan	2016-04-03	8.0 (104)
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)
99	3	181	510	8	956	Dmitrij Grinkevich	2012-05-05	8.1 (71)
202	2	29	504	0	557	qwrqwr	2013-11-01	9.1 (16)
64	3	551	481	47	508	qwrqwr	2010-05-13	7.9 (176)
66	3	629	449	52	392	anddros	2009-12-26	8.4 (241)
127	2	55	443	2	985	GriGrim	2014-12-21	7.7 (24)
107	2	391	425	9	688	Fiolent	2004-02-26	8.2 (91)
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)
115	2	65	388	1	736	selber	2016-05-28	9.1 (25)
142	2	113	388	1	944	paparome	2007-03-24	9.0 (47)
23	3	1463	387	120	249	Palkin	2007-03-29	8.3 (354)
80	2	321	381	10	453	qwrqwr	2011-10-21	8.9 (127)
166	1	59	375	2	449	anddros	2010-07-26	9.6 (30)
170	2	54	332	1	320	qwrqwr	2010-10-24	9.0 (27)
88	3	265	329	5	521	crescent	2011-03-23	8.9 (106)
209	1	33	319	1	735	Baser	2013-12-30	8.0 (15)
36	3	947	312	20	788	risp	2011-05-06	8.0 (293)
92	2	544	311	9	405	paparome	2006-07-26	8.5 (117)
139	2	124	310	2	907	Snowbear	2006-09-09	8.3 (44)
47	3	875	280	15	608	qwrqwr	2010-11-20	8.0 (269)
111	2	440	277	3	545	Fiolent	2005-01-19	8.2 (90)
41	3	1044	276	17	271	qwrqwr	2010-04-26	8.1 (335)
12	1	255	267	38	348	Serge I	2019-04-12	7.2 (67)
60	3	1995	264	119	353	Serge I	2005-03-05	7.8 (316)
54	2	1268	257	44	706	Ozzy	2008-09-06	8.2 (443)
29	2	982	257	43	695	GiBis	2011-09-17	7.5 (318)
262	2	11	243	0	684	selber	2019-06-21	6.5 (6)
118	2	415	236	1	206	Fiolent	2004-01-05	8.2 (81)
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)
91	2	211	222	1	642	smog	2012-05-26	9.1 (85)
34	2	1085	221	25	750	qwrqwr	2010-09-24	7.9 (335)
105	2	126	219	0	610	Baser	2013-09-20	8.5 (47)
122	1	124	217	2	725	Dmitrij Grinkevich	2012-09-14	5.9 (48)
67	2	546	217	16	729	Ozzy	2010-04-27	8.3 (191)
129	2	270	205	7	658	DimaN	2004-03-01	7.5 (57)
40	1	200	202	16	398	Serge I	2018-09-07	7.1 (62)
131	2	88	192	1	498	GriGrim	2012-05-25	8.5 (41)
43	2	444	190	4	648	qwrqwr	2015-04-24	8.5 (146)
75	2	373	189	5	644	qwrqwr	2011-07-22	7.4 (134)
55	2	425	186	4	324	VIG	2005-06-26	7.5 (76)
260	2	52	183	0	999	qwrqwr	2012-02-03	7.7 (35)
303	2	7	182	0	1634	MikhailYakovlev535	2020-06-23	4.5 (4)
20	2	1395	181	34	249	VIG	2003-09-01	8.0 (319)
49	2	1106	178	22	862	anddros	2009-06-05	7.9 (347)
62	2	642	175	10	446	Dmitrij Grinkevich	2012-02-11	8.0 (209)
86	2	329	175	0	433	Ozzy	2010-03-05	8.6 (109)
261	1	35	169	1	1495	Fomichev	2013-12-07	7.0 (19)
61	2	897	167	5	781	risp	2009-12-26	8.4 (301)
203	1	40	160	1	932	=Maxim=	2013-10-05	9.4 (23)
124	2	365	155	3	455	DimaN	2004-02-26	8.3 (80)
16	2	794	153	61	336	qwrqwr	2014-07-18	7.4 (231)
59	2	843	152	6	220	VIG	2003-12-22	8.2 (186)
95	1	79	152	3	350	qwrqwr	2017-12-01	9.4 (34)
304	2	24	151	0	1132	aks_nsk	2016-02-05	9.3 (15)
38	2	946	147	21	297	ZrenBy	2003-09-01	7.6 (188)
74	2	643	143	8	855	vlksm	2008-06-21	8.3 (192)
109	2	480	132	1	671	VIG	2003-12-23	7.9 (89)
104	1	127	128	0	571	pegoopik	2013-07-19	8.3 (53)
201	2	38	127	0	749	Baser	2013-09-21	8.7 (23)
39	2	1298	123	20	263	Serge I	2003-08-28	7.5 (259)
83	2	517	120	4	798	lepton	2006-09-29	8.4 (140)
78	2	396	119	3	451	_ORA_	2010-04-27	7.5 (122)
52	1	419	118	3	274	Serge I	2015-01-10	8.6 (126)
81	2	576	118	12	707	$erges	2008-05-10	8.2 (160)
94	2	242	118	0	773	pickman	2011-04-27	8.2 (88)
35	3	483	109	10	688	Baser	2015-09-18	8.7 (150)
33	2	1164	109	24	358	DimaN	2004-03-01	7.6 (326)
197	1	43	107	0	518	pegoopik	2013-06-10	8.8 (19)
44	2	658	105	7	348	Serge I	2011-11-25	7.9 (211)
79	1	946	104	14	403	Serge I	2003-06-05	7.7 (147)
128	1	224	104	4	829	inkerman	2007-09-14	8.3 (71)
90	1	223	102	0	499	Dmitrij Grinkevich	2012-03-03	7.8 (78)
46	2	1121	102	126	376	Serge I	2009-08-12	6.7 (303)
305	1	25	101	0	160	Baser	2017-01-06	8.9 (14)
51	1	482	100	14	410	Fiolent	2004-06-23	8.0 (129)
57	2	1787	99	14	281	Serge I	2005-05-07	7.8 (292)
70	1	644	99	3	334	Serge I	2009-04-17	7.8 (210)
73	1	433	97	2	367	Ruslan1707	2010-11-02	7.4 (141)
50	1	751	93	6	414	mslava	2003-12-22	8.3 (164)
113	1	122	91	0	497	smog	2013-03-29	8.3 (49)
17	2	1537	88	22	122	VIG	2003-04-29	8.1 (299)
103	1	128	86	1	850	Baser	2013-10-05	7.2 (49)
114	1	438	83	4	298	Serge I	2003-12-24	8.4 (87)
10	1	594	83	41	179	Serge I	2017-01-20	8.0 (178)
256	1	39	82	1	436	anddros	2013-11-08	8.9 (20)
24	2	1530	79	7	631	Aaz	2004-02-26	6.9 (435)
25	2	1139	79	29	208	DimaN	2004-06-22	7.0 (305)
112	1	9	75	0	393	Gosha	2020-06-03	8.8 (6)
26	1	1391	73	24	269	VIG	2003-12-22	7.7 (340)
9	2	1270	72	27	498	vasia armor	2010-05-21	7.9 (376)
8	2	1325	66	74	600	Serge I	2008-06-21	7.6 (340)
28	1	1114	64	14	266	ZrenBy	2003-09-01	7.5 (212)
21	1	1107	63	9	680	paparome	2006-03-14	7.9 (257)
32	1	1267	63	7	529	Roman Golubin	2005-12-13	7.5 (293)
97	1	355	62	3	231	dimzv	2004-03-01	7.7 (76)
42	1	1542	56	14	254	Serge I	2003-06-05	7.6 (296)
117	1	417	55	0	193	Fiolent	2003-12-26	7.5 (77)
18	1	1532	53	6	157	ZrenBy	2003-09-01	7.6 (337)
192	2	48	52	0	709	Baser	2012-03-03	9.2 (25)
27	1	1185	51	8	368	Fiolent	2004-02-26	7.3 (276)
30	1	1660	50	3	154	Serge I	2003-08-28	7.9 (369)
48	1	1081	50	6	317	Serge I	2009-06-22	7.3 (288)
56	1	980	48	3	581	Fiolent	2004-06-22	7.9 (259)
19	1	1898	47	23	279	Serge I	2004-06-23	7.5 (391)
14	1	2339	47	36	116	Serge I	2003-04-08	7.5 (407)
31	1	945	46	7	342	Fiolent	2004-06-22	7.8 (235)
22	1	1526	46	12	261	ZrenBy	2003-09-01	7.2 (353)
108	1	483	46	0	412	mslava	2003-12-23	7.3 (87)
302	0	37	45	0	510	pegoopik	2012-07-27	7.6 (11)
63	1	1265	44	5	190	VIG	2003-06-05	7.6 (227)
7	1	2386	42	75	303	Serge I	2006-11-17	7.9 (445)
53	1	1391	40	25	230	DimaN	2004-03-01	7.6 (360)
13	1	1618	38	21	194	ZrenBy	2003-09-01	7.4 (379)
15	1	1100	34	8	287	Dmitrij Grinkevich	2012-04-21	7.5 (303)
11	1	1788	34	16	130	ZrenBy	2003-09-01	7.4 (406)
306	1	8	17	0	646	Kursist	2020-04-17	9.2 (5)
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)

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References