SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References