SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References