SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References