SQL exercises

March 25, 21:54 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	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	198	9.4	16
59	196	9.4	15
60	215	9.4	14
61	257	9.4	14
62	226	9.4	7
63	87	9.3	185
64	101	9.3	125
65	93	9.3	78
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	40
81	192	9.2	26
82	186	9.2	24
83	88	9.2	23
84	91	9.1	98
85	69	9.1	73
86	120	9.1	61
87	135	9.1	40
88	170	9.1	31
89	156	9.1	30
90	178	9.1	16
91	195	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	147
97	123	9.0	121
98	142	9.0	49
99	115	9.0	44
100	141	9.0	36
101	197	9.0	22
102	256	9.0	21
103	217	9.0	4
104	2	9.0	1
105	-14	9.0	1
106	-8	9.0	1
107	-17	9.0	1
108	-11	9.0	1
109	-2	9.0	1
110	-5	9.0	1
111	76	8.9	193
112	110	8.9	124
113	108	8.9	120
114	130	8.9	63
115	140	8.9	42
116	158	8.9	23
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	171
125	106	8.8	130
126	143	8.8	32
127	254	8.8	27
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	141
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	83	8.6	158
142	86	8.6	125
143	126	8.6	95
144	105	8.6	61
145	177	8.6	28
146	175	8.6	24
147	150	8.6	22
148	238	8.6	5
149	61	8.5	339
150	66	8.5	263
151	85	8.5	154
152	92	8.5	129
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	215
160	71	8.4	201
161	43	8.4	189
162	84	8.4	163
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	176
172	51	8.3	170
173	111	8.3	107
174	94	8.3	98
175	5	8.3	77
176	133	8.3	52
177	139	8.3	47
178	127	8.3	33
179	306	8.3	8
180	262	8.3	7
181	240	8.3	3
182	54	8.2	486
183	17	8.2	343
184	58	8.2	238
185	82	8.2	155
186	98	8.2	139
187	68	8.2	126
188	124	8.2	92
189	99	8.2	88
190	182	8.2	18
191	159	8.2	14
192	41	8.1	381
193	36	8.1	335
194	47	8.1	314
195	21	8.1	293
196	62	8.1	245
197	10	8.1	241
198	64	8.1	206
199	118	8.1	95
200	7	8.1	91
201	9	8.0	443
202	6	8.0	401
203	20	8.0	359
204	56	8.0	293
205	37	8.0	279
206	31	8.0	275
207	45	8.0	145
208	107	8.0	109
209	109	8.0	102
210	90	8.0	90
211	251	8.0	29
212	185	8.0	27
213	209	8.0	15
214	302	8.0	13
215	-4	8.0	1
216	-10	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	4	8.0	1
223	1	8.0	1
224	30	7.9	407
225	49	7.9	391
226	34	7.9	376
227	60	7.9	355
228	44	7.9	255
229	70	7.9	230
230	89	7.9	165
231	65	7.8	267
232	79	7.8	164
233	55	7.8	131
234	8	7.7	407
235	53	7.7	397
236	18	7.7	375
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	454
243	14	7.6	453
244	13	7.6	428
245	15	7.6	344
246	16	7.6	271
247	63	7.6	257
248	28	7.6	247
249	38	7.6	226
250	121	7.6	103
251	97	7.6	87
252	103	7.6	64
253	258	7.6	10
254	19	7.5	429
255	29	7.5	356
256	39	7.5	299
257	73	7.5	160
258	75	7.5	156
259	78	7.5	137
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	50	7.1	129
270	24	7.0	475
271	12	7.0	129
272	40	7.0	104
273	261	7.0	19
274	3	7.0	1
275	-18	7.0	1
276	-6	7.0	1
277	-12	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