SQL exercises

November 05, 17:53 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	192	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	53	9.8	5
22	146	9.7	35
23	164	9.7	22
24	147	9.7	21
25	167	9.7	16
26	236	9.7	10
27	233	9.7	10
28	229	9.7	6
29	119	9.6	67
30	152	9.6	29
31	180	9.6	24
32	160	9.6	19
33	157	9.6	18
34	163	9.6	16
35	213	9.6	15
36	218	9.6	8
37	234	9.6	5
38	102	9.5	96
39	166	9.5	33
40	168	9.5	26
41	176	9.5	22
42	198	9.5	18
43	259	9.5	13
44	191	9.5	12
45	224	9.5	8
46	235	9.5	8
47	239	9.5	4
48	241	9.5	2
49	308	9.5	2
50	100	9.4	137
51	116	9.4	129
52	203	9.4	27
53	304	9.4	16
54	196	9.4	16
55	257	9.4	13
56	220	9.4	5
57	231	9.4	5
58	87	9.3	187
59	101	9.3	126
60	93	9.3	80
61	148	9.3	36
62	162	9.3	35
63	174	9.3	34
64	173	9.3	29
65	149	9.3	24
66	153	9.3	21
67	161	9.3	19
68	171	9.3	16
69	179	9.3	14
70	200	9.3	13
71	215	9.3	13
72	226	9.3	6
73	263	9.3	6
74	72	9.2	289
75	137	9.2	71
76	138	9.2	69
77	95	9.2	49
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	101
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	51
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	174
122	106	8.8	132
123	201	8.8	26
124	187	8.8	22
125	208	8.8	13
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	17
145	61	8.5	339
146	66	8.5	265
147	83	8.5	160
148	85	8.5	155
149	92	8.5	132
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	101
172	5	8.3	78
173	104	8.3	68
174	133	8.3	53
175	139	8.3	48
176	127	8.3	34
177	306	8.3	8
178	262	8.3	7
179	240	8.3	3
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	6	8.1	403
191	41	8.1	381
192	20	8.1	359
193	47	8.1	315
194	21	8.1	293
195	62	8.1	245
196	10	8.1	240
197	64	8.1	206
198	45	8.1	146
199	118	8.1	97
200	7	8.1	94
201	209	8.1	16
202	9	8.0	443
203	36	8.0	336
204	56	8.0	294
205	37	8.0	279
206	31	8.0	275
207	44	8.0	256
208	109	8.0	104
209	251	8.0	30
210	185	8.0	27
211	-10	8.0	1
212	-4	8.0	1
213	-7	8.0	1
214	-1	8.0	1
215	-16	8.0	1
216	-19	8.0	1
217	-13	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	93
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	454
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	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	478
269	50	7.0	130
270	40	7.0	106
271	261	7.0	19
272	-18	7.0	1
273	-6	7.0	1
274	-12	7.0	1
275	-9	7.0	1
276	46	6.9	341
277	237	6.7	3
278	122	5.8	62

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References