SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References