SQL exercises January 09, 11:43 MSK ???-100

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.

 • 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

 • Today statistics
 • Site's old residents
 • Recent leaders activity
 • Сhanges in exercises' TOP 10
 • Results' chart

 • 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)

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

 • About certification
 • Certified professionals
 • Statistics
 • Statistics over regions (map)
 • Confirm certificate

• SQL(DML) help
• SQL Tutorial
• FAQ
• Guide to Exercise Authors
• Databases' scripts
• Download books
• Send message

• Query plan
• Rating by cost
• Optimization competition rules
• Optimization competition

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 #	Average	Rank
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	13
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	23
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	23
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	38
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	121
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	96
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	189	8.7	13
131	217	8.7	3
132	83	8.6	157
133	86	8.6	124
134	126	8.6	95
135	134	8.6	73
136	105	8.6	61
137	175	8.6	23
138	150	8.6	22
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	397
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	71
166	133	8.3	51
167	139	8.3	46
168	127	8.3	32
169	193	8.3	15
170	306	8.3	8
171	262	8.3	7
172	54	8.2	484
173	17	8.2	342
174	47	8.2	312
175	58	8.2	236
176	82	8.2	154
177	98	8.2	139
178	124	8.2	92
179	99	8.2	88
180	182	8.2	18
181	159	8.2	14
182	9	8.1	442
183	41	8.1	380
184	21	8.1	292
185	62	8.1	242
186	10	8.1	240
187	64	8.1	202
188	68	8.1	123
189	118	8.1	95
190	6	8.0	401
191	20	8.0	358
192	36	8.0	332
193	56	8.0	291
194	37	8.0	278
195	45	8.0	143
196	107	8.0	109
197	109	8.0	102
198	7	8.0	90
199	90	8.0	90
200	251	8.0	29
201	185	8.0	27
202	209	8.0	15
203	30	7.9	407
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	406
215	53	7.7	395
216	18	7.7	375
217	26	7.7	372
218	33	7.7	362
219	15	7.7	343
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	453
226	14	7.6	452
227	13	7.6	427
228	16	7.6	270
229	28	7.6	246
230	38	7.6	224
231	121	7.6	103
232	97	7.6	87
233	103	7.6	64
234	258	7.6	10
235	19	7.5	428
236	29	7.5	355
237	39	7.5	297
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	394
246	48	7.4	324
247	27	7.4	312
248	144	7.4	30
249	227	7.3	6
250	25	7.2	341
251	50	7.1	125
252	24	7.0	473
253	12	7.0	128
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

• Certified professionals
• Statistics

• SELECT (learning stage)
• SELECT (learn, choose DBMS)
• SELECT (rating stages)
• DML
• Data simulation

• Learning stage
• Rating stages
• Favorites
• Search

• Top 100
• Today statistics
• Recent leaders activity • Rating of 2nd-stage exercises (median)

• SQL(DML) help
• SQL Tutorial
• FAQ
• Send message

• Query plan
• Rating by cost
• Optimization competition

Profile
References