SQL exercises

July 22, 02: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

Results of exercises voting

In this Section you can see the results of voting for the tasks of the second and the third stages (SELECT exercises) on 10-score scale.
In order to estimate the tasks (if you have solved these yet), click here.

No	Exercise #	Rank	Number of votes
1	194	10.0	14
2	228	10.0	12
3	210	10.0	12
4	207	10.0	11
5	214	10.0	9
6	242	10.0	2
7	-15	10.0	2
8	-3	10.0	2
9	264	10.0	2
10	155	9.9	22
11	154	9.9	20
12	219	9.9	11
13	216	9.9	11
14	225	9.9	10
15	223	9.9	9
16	232	9.9	7
17	165	9.8	20
18	172	9.8	17
19	188	9.8	14
20	233	9.8	12
21	222	9.8	11
22	211	9.8	10
23	255	9.8	10
24	241	9.8	4
25	237	9.8	4
26	146	9.7	36
27	164	9.7	23
28	147	9.7	22
29	167	9.7	17
30	236	9.7	11
31	181	9.7	11
32	218	9.7	9
33	229	9.7	7
34	239	9.7	6
35	234	9.7	6
36	308	9.7	3
37	119	9.6	68
38	152	9.6	30
39	180	9.6	25
40	157	9.6	19
41	160	9.6	19
42	163	9.6	17
43	213	9.6	16
44	259	9.6	14
45	224	9.6	9
46	235	9.6	9
47	220	9.6	7
48	102	9.5	97
49	166	9.5	34
50	168	9.5	27
51	176	9.5	23
52	198	9.5	18
53	196	9.5	17
54	257	9.5	15
55	191	9.5	13
56	226	9.5	8
57	231	9.5	6
58	2	9.5	2
59	-11	9.5	2
60	-17	9.5	2
61	-14	9.5	2
62	-8	9.5	2
63	-5	9.5	2
64	-2	9.5	2
65	100	9.4	138
66	116	9.4	130
67	203	9.4	27
68	161	9.4	20
69	304	9.4	17
70	171	9.4	17
71	179	9.4	16
72	215	9.4	15
73	200	9.4	14
74	230	9.4	8
75	263	9.4	7
76	87	9.3	188
77	101	9.3	128
78	93	9.3	80
79	148	9.3	37
80	162	9.3	36
81	174	9.3	35
82	173	9.3	30
83	149	9.3	25
84	153	9.3	22
85	202	9.3	18
86	72	9.2	290
87	137	9.2	72
88	138	9.2	69
89	95	9.2	49
90	170	9.2	32
91	192	9.2	27
92	186	9.2	25
93	195	9.2	19
94	183	9.2	17
95	206	9.2	13
96	217	9.2	5
97	91	9.1	101
98	69	9.1	74
99	135	9.1	42
100	156	9.1	31
101	88	9.1	27
102	178	9.1	17
103	305	9.1	16
104	80	9.0	149
105	123	9.0	124
106	120	9.0	64
107	142	9.0	51
108	115	9.0	47
109	32	9.0	44
110	140	9.0	44
111	141	9.0	37
112	197	9.0	24
113	256	9.0	23
114	151	9.0	22
115	253	9.0	21
116	190	9.0	16
117	221	9.0	11
118	205	9.0	11
119	-1	9.0	2
120	-7	9.0	2
121	-4	9.0	2
122	-10	9.0	2
123	-16	9.0	2
124	-13	9.0	2
125	-19	9.0	2
126	1	9.0	2
127	76	8.9	195
128	110	8.9	126
129	108	8.9	123
130	130	8.9	65
131	143	8.9	34
132	201	8.9	27
133	158	8.9	25
134	184	8.9	22
135	208	8.9	14
136	212	8.9	12
137	238	8.9	7
138	96	8.8	174
139	106	8.8	133
140	254	8.8	29
141	301	8.8	24
142	187	8.8	23
143	189	8.8	14
144	240	8.8	4
145	35	8.7	200
146	77	8.7	143
147	125	8.7	99
148	126	8.7	97
149	113	8.7	65
150	131	8.7	49
151	145	8.7	35
152	175	8.7	25
153	150	8.7	23
154	24	8.7	18
155	307	8.7	12
156	52	8.6	168
157	83	8.6	161
158	86	8.6	128
159	105	8.6	64
160	177	8.6	29
161	204	8.6	20
162	61	8.5	340
163	66	8.5	266
164	85	8.5	156
165	92	8.5	132
166	134	8.5	76
167	112	8.5	30
168	252	8.5	24
169	169	8.5	23
170	193	8.5	17
171	199	8.5	15
172	262	8.5	8
173	-6	8.5	2
174	-12	8.5	2
175	-9	8.5	2
176	-18	8.5	2
177	3	8.5	2
178	23	8.4	400
179	74	8.4	217
180	71	8.4	202
181	43	8.4	191
182	84	8.4	166
183	114	8.4	105
184	128	8.4	79
185	57	8.4	73
186	104	8.4	70
187	306	8.4	9
188	59	8.3	224
189	67	8.3	220
190	81	8.3	179
191	51	8.3	172
192	111	8.3	110
193	94	8.3	101
194	99	8.3	91
195	133	8.3	54
196	139	8.3	48
197	127	8.3	35
198	182	8.3	19
199	159	8.3	16
200	54	8.2	488
201	41	8.2	383
202	17	8.2	347
203	58	8.2	240
204	82	8.2	157
205	98	8.2	142
206	68	8.2	127
207	124	8.2	95
208	5	8.2	80
209	47	8.1	316
210	21	8.1	295
211	62	8.1	246
212	10	8.1	244
213	64	8.1	207
214	45	8.1	147
215	118	8.1	98
216	251	8.1	31
217	185	8.1	28
218	209	8.1	16
219	302	8.1	14
220	9	8.0	446
221	6	8.0	404
222	20	8.0	362
223	36	8.0	337
224	56	8.0	295
225	37	8.0	281
226	31	8.0	277
227	44	8.0	257
228	109	8.0	105
229	7	8.0	95
230	30	7.9	409
231	49	7.9	393
232	34	7.9	378
233	60	7.9	356
234	70	7.9	231
235	89	7.9	168
236	107	7.9	112
237	90	7.9	93
238	65	7.8	269
239	79	7.8	166
240	55	7.8	133
241	260	7.8	38
242	258	7.8	11
243	8	7.7	409
244	53	7.7	399
245	18	7.7	378
246	26	7.7	375
247	33	7.7	366
248	42	7.7	341
249	117	7.7	94
250	97	7.7	90
251	227	7.7	7
252	14	7.6	457
253	11	7.6	456
254	19	7.6	432
255	13	7.6	431
256	29	7.6	358
257	15	7.6	348
258	16	7.6	273
259	63	7.6	258
260	28	7.6	249
261	38	7.6	227
262	121	7.6	106
263	129	7.6	66
264	136	7.6	55
265	39	7.5	301
266	73	7.5	162
267	75	7.5	158
268	78	7.5	139
269	103	7.5	67
270	144	7.5	31
271	22	7.4	397
272	48	7.4	328
273	27	7.4	315
274	132	7.4	61
275	25	7.2	344
276	261	7.2	20
277	50	7.1	131
278	4	7.0	479
279	12	7.0	132
280	40	7.0	107
281	46	6.9	342
282	122	5.9	63

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References