SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References