SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References