SQL exercises

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References