SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References