SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References