SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References