SQL exercises

July 07, 02:01 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	241	10.0	2
7	264	10.0	1
8	-15	10.0	1
9	-3	10.0	1
10	155	9.9	21
11	154	9.9	19
12	219	9.9	10
13	216	9.9	10
14	225	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	146	9.7	35
24	164	9.7	22
25	147	9.7	21
26	167	9.7	16
27	233	9.7	11
28	236	9.7	10
29	181	9.7	10
30	229	9.7	6
31	237	9.7	3
32	119	9.6	67
33	152	9.6	29
34	180	9.6	24
35	157	9.6	18
36	160	9.6	18
37	163	9.6	16
38	213	9.6	15
39	218	9.6	8
40	239	9.6	5
41	234	9.6	5
42	102	9.5	96
43	166	9.5	33
44	168	9.5	26
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	129
55	203	9.4	26
56	196	9.4	16
57	304	9.4	16
58	215	9.4	14
59	257	9.4	14
60	226	9.4	7
61	231	9.4	5
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	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	123
97	120	9.0	63
98	142	9.0	50
99	115	9.0	46
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	64
117	143	8.9	33
118	158	8.9	24
119	184	8.9	21
120	151	8.9	21
121	253	8.9	20
122	190	8.9	15
123	221	8.9	10
124	205	8.9	10
125	96	8.8	173
126	106	8.8	132
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	98
136	113	8.7	64
137	145	8.7	34
138	24	8.7	16
139	189	8.7	13
140	238	8.7	6
141	52	8.6	167
142	86	8.6	126
143	126	8.6	96
144	105	8.6	63
145	131	8.6	48
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	104
164	128	8.4	78
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	171
175	111	8.3	109
176	94	8.3	100
177	133	8.3	52
178	139	8.3	47
179	127	8.3	34
180	306	8.3	8
181	262	8.3	7
182	240	8.3	3
183	54	8.2	487
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	94
190	99	8.2	90
191	5	8.2	79
192	182	8.2	18
193	159	8.2	15
194	41	8.1	382
195	47	8.1	315
196	21	8.1	294
197	62	8.1	245
198	10	8.1	243
199	64	8.1	206
200	45	8.1	146
201	118	8.1	97
202	9	8.0	445
203	6	8.0	403
204	20	8.0	360
205	36	8.0	336
206	56	8.0	293
207	37	8.0	280
208	31	8.0	276
209	44	8.0	256
210	109	8.0	104
211	7	8.0	94
212	251	8.0	30
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	392
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	132
235	8	7.7	408
236	53	7.7	398
237	18	7.7	376
238	26	7.7	374
239	33	7.7	365
240	42	7.7	340
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	117	7.6	93
253	129	7.6	65
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	121	7.5	105
261	136	7.5	53
262	22	7.4	396
263	48	7.4	327
264	27	7.4	314
265	103	7.4	66
266	132	7.4	60
267	144	7.4	30
268	227	7.3	6
269	25	7.2	343
270	12	7.1	130
271	4	7.0	478
272	50	7.0	130
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.8	62

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References