SQL exercises

June 06, 19:14 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
  • Visual simulation (painting)
  • Exercises voting

Forums

  • Learning stage
  • Rating stages
  • Favorites
  • Search
  • Blogs

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

To vote

Home
Week news

Certification

SQL exercises

Forums

Ratings

HELP

Performance

Profile
References