SQL exercises

March 26, 06:10 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	239	10.0	2
12	154	9.9	19
13	167	9.9	15
14	219	9.9	9
15	216	9.9	8
16	223	9.9	8
17	225	9.9	7
18	165	9.8	19
19	172	9.8	16
20	188	9.8	12
21	255	9.8	9
22	222	9.8	9
23	211	9.8	9
24	230	9.8	5
25	234	9.8	4
26	146	9.7	34
27	164	9.7	22
28	147	9.7	20
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	163	9.6	14
42	218	9.6	8
43	102	9.5	93
44	168	9.5	25
45	176	9.5	21
46	259	9.5	13
47	191	9.5	11
48	224	9.5	8
49	100	9.4	135
50	116	9.4	126
51	95	9.4	46
52	203	9.4	25
53	198	9.4	16
54	304	9.4	16
55	196	9.4	15
56	257	9.4	13
57	87	9.3	184
58	101	9.3	123
59	93	9.3	78
60	148	9.3	36
61	162	9.3	34
62	174	9.3	32
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	303	9.3	7
71	226	9.3	6
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	217	9.0	2
100	110	8.9	123
101	108	8.9	119
102	130	8.9	63
103	140	8.9	42
104	158	8.9	23
105	151	8.9	21
106	197	8.9	20
107	184	8.9	20
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	129
116	143	8.8	32
117	254	8.8	27
118	201	8.8	24
119	187	8.8	21
120	208	8.8	12
121	35	8.7	191
122	77	8.7	138
123	125	8.7	95
124	113	8.7	62
125	131	8.7	47
126	145	8.7	34
127	112	8.7	26
128	301	8.7	22
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	5	8.6	58
136	150	8.6	22
137	189	8.6	12
138	238	8.6	5
139	61	8.5	334
140	66	8.5	260
141	85	8.5	152
142	92	8.5	129
143	114	8.5	101
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	161
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	54	8.2	482
170	17	8.2	339
171	82	8.2	154
172	98	8.2	139
173	124	8.2	91
174	99	8.2	88
175	127	8.2	31
176	159	8.2	14
177	41	8.1	374
178	47	8.1	310
179	21	8.1	289
180	62	8.1	240
181	58	8.1	234
182	10	8.1	233
183	64	8.1	202
184	68	8.1	123
185	118	8.1	95
186	182	8.1	17
187	9	8.0	435
188	6	8.0	396
189	20	8.0	355
190	36	8.0	330
191	56	8.0	289
192	37	8.0	276
193	45	8.0	140
194	107	8.0	108
195	109	8.0	102
196	90	8.0	90
197	7	8.0	80
198	251	8.0	29
199	209	8.0	15
200	30	7.9	404
201	49	7.9	388
202	34	7.9	372
203	60	7.9	351
204	31	7.9	272
205	44	7.9	249
206	70	7.9	228
207	89	7.9	164
208	185	7.9	26
209	79	7.8	162
210	55	7.8	127
211	302	7.8	12
212	8	7.7	397
213	53	7.7	393
214	18	7.7	372
215	26	7.7	368
216	33	7.7	360
217	42	7.7	334
218	65	7.7	263
219	117	7.7	91
220	260	7.7	37
221	11	7.6	450
222	14	7.6	449
223	13	7.6	421
224	15	7.6	339
225	63	7.6	253
226	28	7.6	243
227	121	7.6	103
228	97	7.6	87
229	103	7.6	63
230	258	7.6	10
231	19	7.5	424
232	29	7.5	352
233	39	7.5	294
234	16	7.5	267
235	38	7.5	222
236	73	7.5	159
237	75	7.5	154
238	78	7.5	135
239	129	7.5	63
240	132	7.5	58
241	136	7.5	53
242	22	7.4	391
243	48	7.4	322
244	27	7.4	309
245	144	7.4	30
246	227	7.3	6
247	25	7.2	337
248	50	7.1	123
249	24	7.0	469
250	12	7.0	122
251	40	7.0	97
252	261	7.0	19
253	262	7.0	7
254	46	6.9	335
255	122	5.9	60

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References