SQL exercises

April 24, 18:23 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	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	163	9.7	15
29	181	9.7	10
30	236	9.7	9
31	229	9.7	6
32	235	9.7	6
33	237	9.7	3
34	119	9.6	64
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	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	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	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	161	9.3	18
66	171	9.3	15
67	215	9.3	13
68	200	9.3	13
69	303	9.3	7
70	226	9.3	6
71	239	9.3	3
72	72	9.2	286
73	137	9.2	70
74	138	9.2	67
75	192	9.2	26
76	186	9.2	24
77	88	9.2	19
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	38
84	32	9.1	33
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	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	24
118	187	8.8	21
119	208	8.8	12
120	35	8.7	191
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	5	8.5	60
144	177	8.5	26
145	169	8.5	22
146	175	8.5	22
147	204	8.5	19
148	307	8.5	11
149	23	8.4	393
150	74	8.4	214
151	71	8.4	198
152	43	8.4	185
153	128	8.4	77
154	104	8.4	66
155	57	8.4	65
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	49
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	339
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	374
179	47	8.1	310
180	21	8.1	289
181	62	8.1	240
182	58	8.1	234
183	10	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	436
189	6	8.0	396
190	20	8.0	355
191	36	8.0	330
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	80
199	251	8.0	29
200	209	8.0	15
201	30	7.9	405
202	49	7.9	388
203	34	7.9	372
204	60	7.9	351
205	31	7.9	273
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	398
214	53	7.7	393
215	18	7.7	372
216	26	7.7	369
217	33	7.7	360
218	42	7.7	334
219	65	7.7	263
220	117	7.7	91
221	260	7.7	37
222	11	7.6	451
223	14	7.6	449
224	13	7.6	421
225	15	7.6	339
226	63	7.6	253
227	28	7.6	244
228	121	7.6	103
229	97	7.6	87
230	103	7.6	63
231	258	7.6	10
232	19	7.5	424
233	29	7.5	353
234	39	7.5	294
235	16	7.5	267
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	391
244	48	7.4	322
245	27	7.4	310
246	144	7.4	30
247	227	7.3	6
248	25	7.2	337
249	50	7.1	123
250	24	7.0	470
251	12	7.0	122
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