SQL exercises

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