SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References