SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References