SQL exercises

April 18, 17:14 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
  • Visual simulation (painting)
  • Exercises voting (SELECT)
  • Exercises voting (DML)

Forums

  • Learning stage
  • Rating stages
  • Favorites
  • Search
  • Blogs

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References