SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References