SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References