SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References