SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References