SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References