yCpeJMYp

1DROP TABLE if exists ##users;
2DROP TABLE if exists ##check;
3create table ##users (
4	user_id int
5	, role varchar (20)
6	, class int
7	, letter varchar (1)
8	, subject varchar (20)
9	);
10
11CREATE TABLE ##check (
12	check_id INT
13	, teacher_id INT
14	, class INT
15	, letter VARCHAR (1)
16	);
17
18
19INSERT INTO ##users SELECT 	1,'Учитель',NULL,'','Математика'
20INSERT INTO ##users SELECT 	2,'Учитель',NULL,'','Алгебра'
21INSERT INTO ##users SELECT 	3,'Учитель',NULL,'','Биология'
22INSERT INTO ##users SELECT 	4,'Учитель',NULL,'','История'
23INSERT INTO ##users SELECT 	5,'Учитель',NULL,'','Физика'
24INSERT INTO ##users SELECT 	6,'Учитель',NULL,'','Английский'
25INSERT INTO ##users SELECT 	7,'Учитель',NULL,'','Алгебра'
26INSERT INTO ##users SELECT 	8,'Учитель',NULL,'','История'
27INSERT INTO ##users SELECT 	9,'Учитель',NULL,'','География'
28INSERT INTO ##users SELECT 	10,'Учитель',NULL,'','Математика'
29INSERT INTO ##users SELECT 	11,'Учитель',NULL,'','Геометрия'
30INSERT INTO ##users SELECT 	12,'Учитель',NULL,'','Физика'
31INSERT INTO ##users SELECT 	13,'Учитель',NULL,'','Алгебра'
32INSERT INTO ##users SELECT 	14,'Учитель',NULL,'','Математика'
33INSERT INTO ##users SELECT 	15,'Учитель',NULL,'','Биология'
34INSERT INTO ##users SELECT 	16,'Учитель',NULL,'','История'
35INSERT INTO ##users SELECT 	17,'Учитель',NULL,'','Математика'
36INSERT INTO ##users SELECT 	18,'Учитель',NULL,'','Алгебра'
37INSERT INTO ##users SELECT 	19,'Учитель',NULL,'','Биология'
38INSERT INTO ##users SELECT 	20,'Учитель',NULL,'','Английский'
39INSERT INTO ##users SELECT 	21,'Учитель',NULL,'','География'
40INSERT INTO ##users SELECT 	22,'Учитель',NULL,'','Физика'
41INSERT INTO ##users SELECT 	23,'Учитель',NULL,'','Русский'
42INSERT INTO ##users SELECT 	24,'Учитель',NULL,'','Английский'
43INSERT INTO ##users SELECT 	25,'Учитель',NULL,'','Алгебра'
44INSERT INTO ##users SELECT 	26,'Учитель',NULL,'','История'
45INSERT INTO ##users SELECT 	27,'Учитель',NULL,'','Математика'
46INSERT INTO ##users SELECT 	28,'Учитель',NULL,'','Английский'
47INSERT INTO ##users SELECT 	29,'Учитель',NULL,'','Геометрия'
48INSERT INTO ##users SELECT 	30,'Учитель',NULL,'','Биология'
49INSERT INTO ##users SELECT 	31,'Учитель',NULL,'','История'
50INSERT INTO ##users SELECT 	32,'Учитель',NULL,'','Английский'
51INSERT INTO ##users SELECT 	33,'Учитель',NULL,'','Биология'
52INSERT INTO ##users SELECT 	34,'Учитель',NULL,'','Геометрия'
53INSERT INTO ##users SELECT 	35,'Учитель',NULL,'','Английский'
54INSERT INTO ##users SELECT 	36,'Учитель',NULL,'','География'
55INSERT INTO ##users SELECT 	37,'Учитель',NULL,'','Математика'
56INSERT INTO ##users SELECT 	38,'Учитель',NULL,'','География'
57INSERT INTO ##users SELECT 	39,'Учитель',NULL,'','Биология'
58INSERT INTO ##users SELECT 	40,'Учитель',NULL,'','Геометрия'
59INSERT INTO ##users SELECT 	41,'Учитель',NULL,'','География'
60INSERT INTO ##users SELECT 	42,'Учитель',NULL,'','История'
61INSERT INTO ##users SELECT 	43,'Учитель',NULL,'','География'
62INSERT INTO ##users SELECT 	44,'Учитель',NULL,'','Математика'
63INSERT INTO ##users SELECT 	45,'Учитель',NULL,'','Алгебра'
64INSERT INTO ##users SELECT 	46,'Учитель',NULL,'','Русский'
65INSERT INTO ##users SELECT 	47,'Учитель',NULL,'','Английский'
66INSERT INTO ##users SELECT 	48,'Учитель',NULL,'','Алгебра'
67INSERT INTO ##users SELECT 	49,'Учитель',NULL,'','Английский'
68INSERT INTO ##users SELECT 	50,'Учитель',NULL,'','Алгебра'
69INSERT INTO ##users SELECT 	58,'Школьник',5,'А',''
70INSERT INTO ##users SELECT 	59,'Школьник',5,'А',''
71INSERT INTO ##users SELECT 	60,'Школьник',5,'А',''
72INSERT INTO ##users SELECT 	61,'Школьник',5,'А',''
73INSERT INTO ##users SELECT 	62,'Школьник',5,'А',''
74INSERT INTO ##users SELECT 	63,'Школьник',5,'А',''
75INSERT INTO ##users SELECT 	64,'Школьник',5,'А',''
76INSERT INTO ##users SELECT 	65,'Школьник',5,'А',''
77INSERT INTO ##users SELECT 	66,'Школьник',5,'А',''
78INSERT INTO ##users SELECT 	67,'Школьник',5,'А',''
79INSERT INTO ##users SELECT 	68,'Школьник',5,'А',''
80INSERT INTO ##users SELECT 	69,'Школьник',5,'А',''
81INSERT INTO ##users SELECT 	70,'Школьник',5,'А',''
82INSERT INTO ##users SELECT 	71,'Школьник',5,'А',''
83INSERT INTO ##users SELECT 	72,'Школьник',5,'А',''
84INSERT INTO ##users SELECT 	73,'Школьник',5,'А',''
85INSERT INTO ##users SELECT 	74,'Школьник',5,'А',''
86INSERT INTO ##users SELECT 	75,'Школьник',5,'А',''
87INSERT INTO ##users SELECT 	76,'Школьник',5,'А',''
88INSERT INTO ##users SELECT 	77,'Школьник',5,'А',''
89INSERT INTO ##users SELECT 	78,'Школьник',5,'А',''
90INSERT INTO ##users SELECT 	79,'Школьник',5,'А',''
91INSERT INTO ##users SELECT 	80,'Школьник',5,'А',''
92INSERT INTO ##users SELECT 	81,'Школьник',5,'А',''
93INSERT INTO ##users SELECT 	82,'Школьник',5,'А',''
94INSERT INTO ##users SELECT 	83,'Школьник',5,'А',''
95INSERT INTO ##users SELECT 	84,'Школьник',5,'А',''
96INSERT INTO ##users SELECT 	85,'Школьник',5,'А',''
97INSERT INTO ##users SELECT 	86,'Школьник',5,'А',''
98INSERT INTO ##users SELECT 	87,'Школьник',5,'А',''
99INSERT INTO ##users SELECT 	88,'Школьник',5,'А',''
100INSERT INTO ##users SELECT 	89,'Школьник',5,'А',''
101INSERT INTO ##users SELECT 	90,'Школьник',5,'А',''
102INSERT INTO ##users SELECT 	91,'Школьник',5,'Б',''
103INSERT INTO ##users SELECT 	92,'Школьник',5,'Б',''
104INSERT INTO ##users SELECT 	93,'Школьник',5,'Б',''
105INSERT INTO ##users SELECT 	94,'Школьник',5,'Б',''
106INSERT INTO ##users SELECT 	95,'Школьник',5,'Б',''
107INSERT INTO ##users SELECT 	96,'Школьник',6,'А',''
108INSERT INTO ##users SELECT 	97,'Школьник',6,'А',''
109INSERT INTO ##users SELECT 	98,'Школьник',6,'А',''
110INSERT INTO ##users SELECT 	99,'Школьник',6,'А',''
111INSERT INTO ##users SELECT 	100,'Школьник',6,'А',''
112INSERT INTO ##users SELECT 	101,'Школьник',6,'А',''
113INSERT INTO ##users SELECT 	102,'Школьник',6,'А',''
114INSERT INTO ##users SELECT 	103,'Школьник',6,'А',''
115INSERT INTO ##users SELECT 	104,'Школьник',6,'А',''
116INSERT INTO ##users SELECT 	105,'Школьник',6,'А',''
117INSERT INTO ##users SELECT 	106,'Школьник',6,'А',''
118INSERT INTO ##users SELECT 	107,'Школьник',6,'А',''
119INSERT INTO ##users SELECT 	108,'Школьник',6,'А',''
120INSERT INTO ##users SELECT 	109,'Школьник',6,'А',''
121INSERT INTO ##users SELECT 	110,'Школьник',6,'А',''
122INSERT INTO ##users SELECT 	111,'Школьник',6,'А',''
123INSERT INTO ##users SELECT 	112,'Школьник',6,'А',''
124INSERT INTO ##users SELECT 	113,'Школьник',6,'А',''
125INSERT INTO ##users SELECT 	114,'Школьник',6,'А',''
126INSERT INTO ##users SELECT 	115,'Школьник',6,'А',''
127INSERT INTO ##users SELECT 	116,'Школьник',6,'А',''
128INSERT INTO ##users SELECT 	117,'Школьник',6,'А',''
129INSERT INTO ##users SELECT 	118,'Школьник',6,'А',''
130INSERT INTO ##users SELECT 	119,'Школьник',6,'Б',''
131INSERT INTO ##users SELECT 	120,'Школьник',6,'Б',''
132INSERT INTO ##users SELECT 	121,'Школьник',6,'Б',''
133INSERT INTO ##users SELECT 	122,'Школьник',6,'Б',''
134INSERT INTO ##users SELECT 	123,'Школьник',6,'Б',''
135INSERT INTO ##users SELECT 	124,'Школьник',6,'Б',''
136INSERT INTO ##users SELECT 	125,'Школьник',6,'Б',''
137INSERT INTO ##users SELECT 	126,'Школьник',6,'Б',''
138INSERT INTO ##users SELECT 	127,'Школьник',6,'Б',''
139INSERT INTO ##users SELECT 	128,'Школьник',6,'Б',''
140INSERT INTO ##users SELECT 	129,'Школьник',6,'Б',''
141INSERT INTO ##users SELECT 	130,'Школьник',6,'Б',''
142INSERT INTO ##users SELECT 	131,'Школьник',6,'Б',''
143INSERT INTO ##users SELECT 	132,'Школьник',6,'Б',''
144INSERT INTO ##users SELECT 	133,'Школьник',6,'Б',''
145INSERT INTO ##users SELECT 	134,'Школьник',6,'Б',''
146INSERT INTO ##users SELECT 	135,'Школьник',6,'Б',''
147INSERT INTO ##users SELECT 	136,'Школьник',6,'Б',''
148INSERT INTO ##users SELECT 	137,'Школьник',6,'Б',''
149INSERT INTO ##users SELECT 	138,'Школьник',6,'Б',''
150INSERT INTO ##users SELECT 	139,'Школьник',6,'Б',''
151INSERT INTO ##users SELECT 	140,'Школьник',6,'Б',''
152INSERT INTO ##users SELECT 	141,'Школьник',6,'Б',''
153INSERT INTO ##users SELECT 	142,'Школьник',6,'Б',''
154INSERT INTO ##users SELECT 	143,'Школьник',6,'Б',''
155INSERT INTO ##users SELECT 	144,'Школьник',6,'Б',''
156INSERT INTO ##users SELECT 	145,'Школьник',6,'Б',''
157INSERT INTO ##users SELECT 	146,'Школьник',6,'Б',''
158INSERT INTO ##users SELECT 	147,'Школьник',6,'Б',''
159INSERT INTO ##users SELECT 	148,'Школьник',6,'Б',''
160INSERT INTO ##users SELECT 	149,'Школьник',6,'Б',''
161INSERT INTO ##users SELECT 	150,'Школьник',6,'Б',''
162INSERT INTO ##users SELECT 	151,'Школьник',6,'Б',''
163INSERT INTO ##users SELECT 	152,'Школьник',6,'Б',''
164INSERT INTO ##users SELECT 	153,'Школьник',6,'Б',''
165INSERT INTO ##users SELECT 	154,'Школьник',6,'Б',''
166INSERT INTO ##users SELECT 	155,'Школьник',6,'Б',''
167INSERT INTO ##users SELECT 	156,'Школьник',6,'Б',''
168INSERT INTO ##users SELECT 	157,'Школьник',6,'Б',''
169INSERT INTO ##users SELECT 	158,'Школьник',6,'Б',''
170INSERT INTO ##users SELECT 	159,'Школьник',6,'Б',''
171INSERT INTO ##users SELECT 	160,'Школьник',6,'Б',''
172INSERT INTO ##users SELECT 	161,'Школьник',6,'В',''
173INSERT INTO ##users SELECT 	162,'Школьник',6,'В',''
174INSERT INTO ##users SELECT 	163,'Школьник',6,'В',''
175INSERT INTO ##users SELECT 	164,'Школьник',6,'В',''
176INSERT INTO ##users SELECT 	165,'Школьник',6,'В',''
177INSERT INTO ##users SELECT 	166,'Школьник',7,'А',''
178INSERT INTO ##users SELECT 	167,'Школьник',7,'А',''
179INSERT INTO ##users SELECT 	168,'Школьник',7,'А',''
180INSERT INTO ##users SELECT 	169,'Школьник',7,'А',''
181INSERT INTO ##users SELECT 	170,'Школьник',7,'А',''
182INSERT INTO ##users SELECT 	171,'Школьник',7,'А',''
183INSERT INTO ##users SELECT 	172,'Школьник',7,'А',''
184INSERT INTO ##users SELECT 	173,'Школьник',7,'А',''
185INSERT INTO ##users SELECT 	174,'Школьник',7,'А',''
186INSERT INTO ##users SELECT 	175,'Школьник',7,'А',''
187INSERT INTO ##users SELECT 	176,'Школьник',7,'А',''
188INSERT INTO ##users SELECT 	177,'Школьник',7,'А',''
189INSERT INTO ##users SELECT 	178,'Школьник',7,'А',''
190INSERT INTO ##users SELECT 	179,'Школьник',7,'А',''
191INSERT INTO ##users SELECT 	180,'Школьник',7,'А',''
192INSERT INTO ##users SELECT 	181,'Школьник',7,'А',''
193INSERT INTO ##users SELECT 	182,'Школьник',7,'А',''
194INSERT INTO ##users SELECT 	183,'Школьник',7,'А',''
195INSERT INTO ##users SELECT 	184,'Школьник',7,'А',''
196INSERT INTO ##users SELECT 	185,'Школьник',7,'А',''
197INSERT INTO ##users SELECT 	186,'Школьник',7,'А',''
198INSERT INTO ##users SELECT 	187,'Школьник',7,'А',''
199INSERT INTO ##users SELECT 	188,'Школьник',7,'А',''
200INSERT INTO ##users SELECT 	189,'Школьник',7,'А',''
201INSERT INTO ##users SELECT 	190,'Школьник',7,'А',''
202INSERT INTO ##users SELECT 	191,'Школьник',7,'А',''
203INSERT INTO ##users SELECT 	192,'Школьник',7,'А',''
204INSERT INTO ##users SELECT 	193,'Школьник',7,'А',''
205INSERT INTO ##users SELECT 	194,'Школьник',7,'А',''
206INSERT INTO ##users SELECT 	195,'Школьник',7,'А',''
207INSERT INTO ##users SELECT 	196,'Школьник',7,'А',''
208INSERT INTO ##users SELECT 	197,'Школьник',7,'А',''
209INSERT INTO ##users SELECT 	198,'Школьник',7,'А',''
210INSERT INTO ##users SELECT 	199,'Школьник',7,'А',''
211INSERT INTO ##users SELECT 	200,'Школьник',7,'А',''
212INSERT INTO ##users SELECT 	201,'Школьник',7,'А',''
213INSERT INTO ##users SELECT 	202,'Школьник',7,'А',''
214INSERT INTO ##users SELECT 	203,'Школьник',7,'А',''
215INSERT INTO ##users SELECT 	204,'Школьник',7,'А',''
216INSERT INTO ##users SELECT 	205,'Школьник',7,'А',''
217INSERT INTO ##users SELECT 	206,'Школьник',7,'А',''
218INSERT INTO ##users SELECT 	207,'Школьник',7,'А',''
219INSERT INTO ##users SELECT 	208,'Школьник',7,'А',''
220INSERT INTO ##users SELECT 	209,'Школьник',7,'А',''
221INSERT INTO ##users SELECT 	210,'Школьник',7,'А',''
222INSERT INTO ##users SELECT 	211,'Школьник',7,'А',''
223INSERT INTO ##users SELECT 	212,'Школьник',7,'А',''
224INSERT INTO ##users SELECT 	213,'Школьник',7,'А',''
225INSERT INTO ##users SELECT 	214,'Школьник',7,'Б',''
226INSERT INTO ##users SELECT 	215,'Школьник',7,'Б',''
227INSERT INTO ##users SELECT 	216,'Школьник',7,'Б',''
228INSERT INTO ##users SELECT 	217,'Школьник',7,'Б',''
229INSERT INTO ##users SELECT 	218,'Школьник',7,'Б',''
230INSERT INTO ##users SELECT 	219,'Школьник',7,'Б',''
231INSERT INTO ##users SELECT 	220,'Школьник',7,'Б',''
232INSERT INTO ##users SELECT 	221,'Школьник',7,'Б',''
233INSERT INTO ##users SELECT 	222,'Школьник',7,'Б',''
234INSERT INTO ##users SELECT 	223,'Школьник',7,'Б',''
235INSERT INTO ##users SELECT 	224,'Школьник',7,'Б',''
236INSERT INTO ##users SELECT 	225,'Школьник',7,'Б',''
237INSERT INTO ##users SELECT 	226,'Школьник',7,'Б',''
238INSERT INTO ##users SELECT 	227,'Школьник',7,'Б',''
239INSERT INTO ##users SELECT 	228,'Школьник',7,'Б',''
240INSERT INTO ##users SELECT 	229,'Школьник',7,'Б',''
241INSERT INTO ##users SELECT 	230,'Школьник',7,'Б',''
242INSERT INTO ##users SELECT 	231,'Школьник',7,'Б',''
243INSERT INTO ##users SELECT 	232,'Школьник',7,'Б',''
244INSERT INTO ##users SELECT 	233,'Школьник',7,'Б',''
245INSERT INTO ##users SELECT 	234,'Школьник',7,'Б',''
246INSERT INTO ##users SELECT 	235,'Школьник',7,'Б',''
247INSERT INTO ##users SELECT 	236,'Школьник',7,'Б',''
248INSERT INTO ##users SELECT 	237,'Школьник',7,'Б',''
249INSERT INTO ##users SELECT 	238,'Школьник',8,'А',''
250INSERT INTO ##users SELECT 	239,'Школьник',8,'А',''
251INSERT INTO ##users SELECT 	240,'Школьник',8,'А',''
252INSERT INTO ##users SELECT 	241,'Школьник',8,'А',''
253INSERT INTO ##users SELECT 	242,'Школьник',8,'А',''
254INSERT INTO ##users SELECT 	243,'Школьник',8,'А',''
255INSERT INTO ##users SELECT 	244,'Школьник',8,'А',''
256INSERT INTO ##users SELECT 	245,'Школьник',8,'А',''
257INSERT INTO ##users SELECT 	246,'Школьник',8,'А',''
258INSERT INTO ##users SELECT 	247,'Школьник',8,'А',''
259INSERT INTO ##users SELECT 	248,'Школьник',8,'А',''
260INSERT INTO ##users SELECT 	249,'Школьник',8,'А',''
261INSERT INTO ##users SELECT 	250,'Школьник',8,'А',''
262INSERT INTO ##users SELECT 	251,'Школьник',8,'А',''
263INSERT INTO ##users SELECT 	252,'Школьник',8,'А',''
264INSERT INTO ##users SELECT 	253,'Школьник',8,'А',''
265INSERT INTO ##users SELECT 	254,'Школьник',8,'А',''
266INSERT INTO ##users SELECT 	255,'Школьник',8,'А',''
267INSERT INTO ##users SELECT 	256,'Школьник',8,'А',''
268INSERT INTO ##users SELECT 	257,'Школьник',8,'А',''
269INSERT INTO ##users SELECT 	258,'Школьник',8,'А',''
270INSERT INTO ##users SELECT 	259,'Школьник',8,'А',''
271INSERT INTO ##users SELECT 	260,'Школьник',8,'А',''
272INSERT INTO ##users SELECT 	261,'Школьник',8,'А',''
273INSERT INTO ##users SELECT 	262,'Школьник',8,'А',''
274INSERT INTO ##users SELECT 	263,'Школьник',8,'А',''
275INSERT INTO ##users SELECT 	264,'Школьник',8,'А',''
276INSERT INTO ##users SELECT 	265,'Школьник',8,'А',''
277INSERT INTO ##users SELECT 	266,'Школьник',8,'А',''
278INSERT INTO ##users SELECT 	267,'Школьник',8,'А',''
279INSERT INTO ##users SELECT 	268,'Школьник',8,'А',''
280INSERT INTO ##users SELECT 	269,'Школьник',8,'А',''
281INSERT INTO ##users SELECT 	270,'Школьник',8,'А',''
282INSERT INTO ##users SELECT 	271,'Школьник',8,'А',''
283INSERT INTO ##users SELECT 	272,'Школьник',8,'А',''
284INSERT INTO ##users SELECT 	273,'Школьник',8,'А',''
285INSERT INTO ##users SELECT 	274,'Школьник',8,'А',''
286INSERT INTO ##users SELECT 	275,'Школьник',8,'А',''
287INSERT INTO ##users SELECT 	276,'Школьник',8,'А',''
288INSERT INTO ##users SELECT 	277,'Школьник',8,'А',''
289INSERT INTO ##users SELECT 	278,'Школьник',8,'А',''
290INSERT INTO ##users SELECT 	279,'Школьник',8,'А',''
291INSERT INTO ##users SELECT 	280,'Школьник',8,'А',''
292INSERT INTO ##users SELECT 	281,'Школьник',8,'А',''
293INSERT INTO ##users SELECT 	282,'Школьник',8,'А',''
294INSERT INTO ##users SELECT 	283,'Школьник',8,'А',''
295INSERT INTO ##users SELECT 	284,'Школьник',8,'А',''
296INSERT INTO ##users SELECT 	285,'Школьник',8,'А',''
297INSERT INTO ##users SELECT 	286,'Школьник',8,'А',''
298INSERT INTO ##users SELECT 	287,'Школьник',8,'А',''
299INSERT INTO ##users SELECT 	288,'Школьник',8,'А',''
300INSERT INTO ##users SELECT 	289,'Школьник',8,'А',''
301INSERT INTO ##users SELECT 	290,'Школьник',8,'А',''
302INSERT INTO ##users SELECT 	291,'Школьник',8,'А',''
303INSERT INTO ##users SELECT 	292,'Школьник',8,'А',''
304INSERT INTO ##users SELECT 	293,'Школьник',8,'А',''
305INSERT INTO ##users SELECT 	294,'Школьник',8,'А',''
306INSERT INTO ##users SELECT 	295,'Школьник',8,'А',''
307INSERT INTO ##users SELECT 	296,'Школьник',8,'А',''
308INSERT INTO ##users SELECT 	297,'Школьник',8,'А',''
309INSERT INTO ##users SELECT 	298,'Школьник',8,'Б',''
310INSERT INTO ##users SELECT 	299,'Школьник',8,'Б',''
311INSERT INTO ##users SELECT 	300,'Школьник',8,'Б',''
312INSERT INTO ##users SELECT 	301,'Школьник',8,'Б',''
313INSERT INTO ##users SELECT 	302,'Школьник',8,'Б',''
314INSERT INTO ##users SELECT 	303,'Школьник',8,'Б',''
315INSERT INTO ##users SELECT 	304,'Школьник',8,'Б',''
316INSERT INTO ##users SELECT 	305,'Школьник',8,'В',''
317INSERT INTO ##users SELECT 	306,'Школьник',8,'В',''
318INSERT INTO ##users SELECT 	307,'Школьник',8,'В',''
319INSERT INTO ##users SELECT 	308,'Школьник',8,'В',''
320INSERT INTO ##users SELECT 	309,'Школьник',8,'В',''
321INSERT INTO ##users SELECT 	310,'Школьник',8,'В',''
322INSERT INTO ##users SELECT 	311,'Школьник',8,'В',''
323INSERT INTO ##users SELECT 	312,'Школьник',8,'В',''
324INSERT INTO ##users SELECT 	313,'Школьник',8,'В',''
325INSERT INTO ##users SELECT 	314,'Школьник',8,'В',''
326INSERT INTO ##users SELECT 	315,'Школьник',8,'В',''
327INSERT INTO ##users SELECT 	316,'Школьник',8,'В',''
328INSERT INTO ##users SELECT 	317,'Школьник',8,'В',''
329INSERT INTO ##users SELECT 	318,'Школьник',8,'В',''
330INSERT INTO ##users SELECT 	319,'Школьник',8,'В',''
331INSERT INTO ##users SELECT 	320,'Школьник',8,'В',''
332INSERT INTO ##users SELECT 	321,'Школьник',8,'В',''
333INSERT INTO ##users SELECT 	322,'Школьник',8,'В',''
334INSERT INTO ##users SELECT 	323,'Школьник',8,'В',''
335INSERT INTO ##users SELECT 	324,'Школьник',8,'В',''
336INSERT INTO ##users SELECT 	325,'Школьник',8,'В',''
337INSERT INTO ##users SELECT 	326,'Школьник',8,'В',''
338INSERT INTO ##users SELECT 	327,'Школьник',8,'В',''
339INSERT INTO ##users SELECT 	328,'Школьник',8,'В',''
340INSERT INTO ##users SELECT 	329,'Школьник',8,'В',''
341INSERT INTO ##users SELECT 	330,'Школьник',8,'В',''
342INSERT INTO ##users SELECT 	331,'Школьник',8,'В',''
343INSERT INTO ##users SELECT 	332,'Школьник',8,'В',''
344INSERT INTO ##users SELECT 	333,'Школьник',8,'В',''
345INSERT INTO ##users SELECT 	334,'Школьник',8,'В',''
346INSERT INTO ##users SELECT 	335,'Школьник',8,'В',''
347INSERT INTO ##users SELECT 	336,'Школьник',8,'В',''
348INSERT INTO ##users SELECT 	337,'Школьник',8,'В',''
349INSERT INTO ##users SELECT 	338,'Школьник',8,'В',''
350INSERT INTO ##users SELECT 	339,'Школьник',8,'В',''
351INSERT INTO ##users SELECT 	340,'Школьник',8,'В',''
352INSERT INTO ##users SELECT 	341,'Школьник',8,'В',''
353INSERT INTO ##users SELECT 	342,'Школьник',8,'В',''
354INSERT INTO ##users SELECT 	343,'Школьник',8,'В',''
355INSERT INTO ##users SELECT 	344,'Школьник',8,'В',''
356INSERT INTO ##users SELECT 	345,'Школьник',8,'В',''
357INSERT INTO ##users SELECT 	346,'Школьник',8,'В',''
358INSERT INTO ##users SELECT 	347,'Школьник',8,'В',''
359INSERT INTO ##users SELECT 	348,'Школьник',8,'В',''
360INSERT INTO ##users SELECT 	349,'Школьник',8,'В',''
361INSERT INTO ##users SELECT 	350,'Школьник',8,'Г',''
362INSERT INTO ##users SELECT 	351,'Школьник',8,'Г',''
363INSERT INTO ##users SELECT 	352,'Школьник',8,'Г',''
364INSERT INTO ##users SELECT 	353,'Школьник',8,'Г',''
365INSERT INTO ##users SELECT 	354,'Школьник',8,'Г',''
366INSERT INTO ##users SELECT 	355,'Школьник',8,'Г',''
367INSERT INTO ##users SELECT 	356,'Школьник',8,'Д',''
368INSERT INTO ##users SELECT 	357,'Школьник',8,'Д',''
369INSERT INTO ##users SELECT 	358,'Школьник',8,'Д',''
370INSERT INTO ##users SELECT 	359,'Школьник',8,'Д',''
371INSERT INTO ##users SELECT 	360,'Школьник',8,'Д',''
372INSERT INTO ##users SELECT 	361,'Школьник',9,'А',''
373INSERT INTO ##users SELECT 	362,'Школьник',9,'А',''
374INSERT INTO ##users SELECT 	363,'Школьник',9,'А',''
375INSERT INTO ##users SELECT 	364,'Школьник',9,'А',''
376INSERT INTO ##users SELECT 	365,'Школьник',9,'А',''
377INSERT INTO ##users SELECT 	366,'Школьник',9,'А',''
378INSERT INTO ##users SELECT 	367,'Школьник',9,'А',''
379INSERT INTO ##users SELECT 	368,'Школьник',9,'А',''
380INSERT INTO ##users SELECT 	369,'Школьник',9,'А',''
381INSERT INTO ##users SELECT 	370,'Школьник',9,'А',''
382INSERT INTO ##users SELECT 	371,'Школьник',9,'А',''
383INSERT INTO ##users SELECT 	372,'Школьник',9,'А',''
384INSERT INTO ##users SELECT 	373,'Школьник',9,'А',''
385INSERT INTO ##users SELECT 	374,'Школьник',9,'А',''
386INSERT INTO ##users SELECT 	375,'Школьник',9,'А',''
387INSERT INTO ##users SELECT 	376,'Школьник',9,'А',''
388INSERT INTO ##users SELECT 	377,'Школьник',9,'А',''
389INSERT INTO ##users SELECT 	378,'Школьник',9,'А',''
390INSERT INTO ##users SELECT 	379,'Школьник',9,'А',''
391INSERT INTO ##users SELECT 	380,'Школьник',9,'А',''
392INSERT INTO ##users SELECT 	381,'Школьник',9,'А',''
393INSERT INTO ##users SELECT 	382,'Школьник',9,'А',''
394INSERT INTO ##users SELECT 	383,'Школьник',9,'А',''
395INSERT INTO ##users SELECT 	384,'Школьник',9,'А',''
396INSERT INTO ##users SELECT 	385,'Школьник',9,'А',''
397INSERT INTO ##users SELECT 	386,'Школьник',9,'А',''
398INSERT INTO ##users SELECT 	387,'Школьник',9,'А',''
399INSERT INTO ##users SELECT 	388,'Школьник',9,'А',''
400INSERT INTO ##users SELECT 	389,'Школьник',9,'А',''
401INSERT INTO ##users SELECT 	390,'Школьник',9,'А',''
402INSERT INTO ##users SELECT 	391,'Школьник',9,'А',''
403INSERT INTO ##users SELECT 	392,'Школьник',9,'А',''
404INSERT INTO ##users SELECT 	393,'Школьник',9,'А',''
405INSERT INTO ##users SELECT 	394,'Школьник',9,'А',''
406INSERT INTO ##users SELECT 	395,'Школьник',9,'А',''
407INSERT INTO ##users SELECT 	396,'Школьник',9,'А',''
408INSERT INTO ##users SELECT 	397,'Школьник',9,'А',''
409INSERT INTO ##users SELECT 	398,'Школьник',9,'А',''
410INSERT INTO ##users SELECT 	399,'Школьник',9,'А',''
411INSERT INTO ##users SELECT 	400,'Школьник',9,'А',''
412INSERT INTO ##users SELECT 	401,'Школьник',9,'А',''
413INSERT INTO ##users SELECT 	402,'Школьник',9,'А',''
414INSERT INTO ##users SELECT 	403,'Школьник',9,'А',''
415INSERT INTO ##users SELECT 	404,'Школьник',9,'А',''
416INSERT INTO ##users SELECT 	405,'Школьник',9,'А',''
417INSERT INTO ##users SELECT 	406,'Школьник',9,'А',''
418INSERT INTO ##users SELECT 	407,'Школьник',9,'А',''
419INSERT INTO ##users SELECT 	408,'Школьник',9,'А',''
420INSERT INTO ##users SELECT 	409,'Школьник',9,'Б',''
421INSERT INTO ##users SELECT 	410,'Школьник',9,'Б',''
422INSERT INTO ##users SELECT 	411,'Школьник',9,'Б',''
423INSERT INTO ##users SELECT 	412,'Школьник',9,'Б',''
424INSERT INTO ##users SELECT 	413,'Школьник',9,'Б',''
425INSERT INTO ##users SELECT 	414,'Школьник',9,'Б',''
426INSERT INTO ##users SELECT 	415,'Школьник',9,'Б',''
427INSERT INTO ##users SELECT 	416,'Школьник',9,'Б',''
428INSERT INTO ##users SELECT 	417,'Школьник',9,'Б',''
429INSERT INTO ##users SELECT 	418,'Школьник',9,'Б',''
430INSERT INTO ##users SELECT 	419,'Школьник',9,'Б',''
431INSERT INTO ##users SELECT 	420,'Школьник',9,'Б',''
432INSERT INTO ##users SELECT 	421,'Школьник',9,'Б',''
433INSERT INTO ##users SELECT 	422,'Школьник',9,'Б',''
434INSERT INTO ##users SELECT 	423,'Школьник',9,'Б',''
435INSERT INTO ##users SELECT 	424,'Школьник',9,'Б',''
436INSERT INTO ##users SELECT 	425,'Школьник',9,'Б',''
437INSERT INTO ##users SELECT 	426,'Школьник',9,'Б',''
438INSERT INTO ##users SELECT 	427,'Школьник',9,'Б',''
439INSERT INTO ##users SELECT 	428,'Школьник',9,'Б',''
440INSERT INTO ##users SELECT 	429,'Школьник',9,'Б',''
441INSERT INTO ##users SELECT 	430,'Школьник',9,'Б',''
442INSERT INTO ##users SELECT 	431,'Школьник',9,'Б',''
443INSERT INTO ##users SELECT 	432,'Школьник',10,'А',''
444INSERT INTO ##users SELECT 	433,'Школьник',10,'А',''
445INSERT INTO ##users SELECT 	434,'Школьник',10,'А',''
446INSERT INTO ##users SELECT 	435,'Школьник',10,'А',''
447INSERT INTO ##users SELECT 	436,'Школьник',10,'А',''
448INSERT INTO ##users SELECT 	437,'Школьник',10,'А',''
449INSERT INTO ##users SELECT 	438,'Школьник',10,'А',''
450INSERT INTO ##users SELECT 	439,'Школьник',10,'А',''
451INSERT INTO ##users SELECT 	440,'Школьник',10,'А',''
452INSERT INTO ##users SELECT 	441,'Школьник',10,'А',''
453INSERT INTO ##users SELECT 	442,'Школьник',10,'А',''
454INSERT INTO ##users SELECT 	443,'Школьник',10,'А',''
455INSERT INTO ##users SELECT 	444,'Школьник',10,'А',''
456INSERT INTO ##users SELECT 	445,'Школьник',10,'А',''
457INSERT INTO ##users SELECT 	446,'Школьник',10,'А',''
458INSERT INTO ##users SELECT 	447,'Школьник',10,'А',''
459INSERT INTO ##users SELECT 	448,'Школьник',10,'А',''
460INSERT INTO ##users SELECT 	449,'Школьник',10,'А',''
461INSERT INTO ##users SELECT 	450,'Школьник',10,'А',''
462INSERT INTO ##users SELECT 	451,'Школьник',10,'А',''
463INSERT INTO ##users SELECT 	452,'Школьник',10,'А',''
464INSERT INTO ##users SELECT 	453,'Школьник',10,'А',''
465INSERT INTO ##users SELECT 	454,'Школьник',10,'А',''
466INSERT INTO ##users SELECT 	455,'Школьник',10,'А',''
467INSERT INTO ##users SELECT 	456,'Школьник',10,'А',''
468INSERT INTO ##users SELECT 	457,'Школьник',10,'А',''
469INSERT INTO ##users SELECT 	458,'Школьник',10,'А',''
470INSERT INTO ##users SELECT 	459,'Школьник',10,'А',''
471INSERT INTO ##users SELECT 	460,'Школьник',10,'А',''
472INSERT INTO ##users SELECT 	461,'Школьник',10,'А',''
473INSERT INTO ##users SELECT 	462,'Школьник',10,'А',''
474INSERT INTO ##users SELECT 	463,'Школьник',10,'А',''
475INSERT INTO ##users SELECT 	464,'Школьник',10,'А',''
476INSERT INTO ##users SELECT 	465,'Школьник',10,'А',''
477INSERT INTO ##users SELECT 	466,'Школьник',10,'А',''
478INSERT INTO ##users SELECT 	467,'Школьник',10,'А',''
479INSERT INTO ##users SELECT 	468,'Школьник',10,'А',''
480INSERT INTO ##users SELECT 	469,'Школьник',10,'А',''
481INSERT INTO ##users SELECT 	470,'Школьник',11,'А',''
482INSERT INTO ##users SELECT 	471,'Школьник',11,'А',''
483INSERT INTO ##users SELECT 	472,'Школьник',11,'А',''
484INSERT INTO ##users SELECT 	473,'Школьник',11,'А',''
485INSERT INTO ##users SELECT 	474,'Школьник',11,'А',''
486INSERT INTO ##users SELECT 	475,'Школьник',11,'А',''
487INSERT INTO ##users SELECT 	476,'Школьник',11,'А',''
488INSERT INTO ##users SELECT 	477,'Школьник',11,'А',''
489INSERT INTO ##users SELECT 	478,'Школьник',11,'А',''
490INSERT INTO ##users SELECT 	479,'Школьник',11,'А',''
491INSERT INTO ##users SELECT 	480,'Школьник',11,'А',''
492INSERT INTO ##users SELECT 	481,'Школьник',11,'А',''
493INSERT INTO ##users SELECT 	482,'Школьник',11,'А',''
494INSERT INTO ##users SELECT 	483,'Школьник',11,'А',''
495INSERT INTO ##users SELECT 	484,'Школьник',11,'А',''
496INSERT INTO ##users SELECT 	485,'Школьник',11,'А',''
497INSERT INTO ##users SELECT 	486,'Школьник',11,'А',''
498INSERT INTO ##users SELECT 	487,'Школьник',11,'А',''
499INSERT INTO ##users SELECT 	488,'Школьник',11,'А',''
500INSERT INTO ##users SELECT 	489,'Школьник',11,'А',''
501INSERT INTO ##users SELECT 	490,'Школьник',11,'Б',''
502INSERT INTO ##users SELECT 	491,'Школьник',11,'Б',''
503INSERT INTO ##users SELECT 	492,'Школьник',11,'Б',''
504INSERT INTO ##users SELECT 	493,'Школьник',11,'Б',''
505INSERT INTO ##users SELECT 	494,'Школьник',11,'Б',''
506INSERT INTO ##users SELECT 	495,'Школьник',11,'Б',''
507INSERT INTO ##users SELECT 	496,'Школьник',11,'Б',''
508INSERT INTO ##users SELECT 	497,'Школьник',11,'Б',''
509INSERT INTO ##users SELECT 	498,'Школьник',11,'Б',''
510INSERT INTO ##users SELECT 	499,'Школьник',11,'Б',''
511INSERT INTO ##users SELECT 	500,'Школьник',11,'Б',''
512INSERT INTO ##users SELECT 	501,'Школьник',11,'Б',''
513INSERT INTO ##users SELECT 	502,'Школьник',11,'Б',''
514INSERT INTO ##users SELECT 	503,'Школьник',11,'Б',''
515INSERT INTO ##users SELECT 	504,'Школьник',11,'Б',''
516INSERT INTO ##users SELECT 	505,'Школьник',11,'Б',''
517INSERT INTO ##users SELECT 	506,'Школьник',11,'Б',''
518INSERT INTO ##users SELECT 	507,'Школьник',11,'Б',''
519INSERT INTO ##users SELECT 	508,'Школьник',11,'Б',''
520INSERT INTO ##users SELECT 	509,'Школьник',11,'Б',''
521INSERT INTO ##users SELECT 	510,'Школьник',11,'Б',''
522INSERT INTO ##users SELECT 	511,'Школьник',11,'Б',''
523INSERT INTO ##users SELECT 	512,'Школьник',11,'Б',''
524INSERT INTO ##users SELECT 	513,'Школьник',11,'Б',''
525INSERT INTO ##users SELECT 	514,'Школьник',11,'Б',''
526INSERT INTO ##users SELECT 	515,'Школьник',11,'Б',''
527INSERT INTO ##users SELECT 	516,'Школьник',11,'Б',''
528INSERT INTO ##users SELECT 	517,'Школьник',11,'Б',''
529INSERT INTO ##users SELECT 	518,'Школьник',11,'Б',''
530INSERT INTO ##users SELECT 	519,'Школьник',11,'Б',''
531INSERT INTO ##users SELECT 	520,'Школьник',11,'Б',''
532INSERT INTO ##users SELECT 	521,'Школьник',11,'Б',''
533INSERT INTO ##users SELECT 	522,'Школьник',11,'Б',''
534INSERT INTO ##users SELECT 	523,'Школьник',11,'Б',''
535INSERT INTO ##users SELECT 	524,'Школьник',11,'Б',''
536INSERT INTO ##users SELECT 	525,'Школьник',11,'Б',''
537INSERT INTO ##users SELECT 	526,'Школьник',11,'Б',''
538INSERT INTO ##users SELECT 	527,'Школьник',11,'Б',''
539INSERT INTO ##users SELECT 	528,'Школьник',11,'Б',''
540INSERT INTO ##users SELECT 	529,'Школьник',11,'Б',''
541INSERT INTO ##users SELECT 	530,'Школьник',11,'Б',''
542INSERT INTO ##users SELECT 	531,'Школьник',11,'Б',''
543INSERT INTO ##users SELECT 	532,'Школьник',11,'Б',''
544INSERT INTO ##users SELECT 	533,'Школьник',11,'Б',''
545INSERT INTO ##users SELECT 	534,'Школьник',11,'Б',''
546INSERT INTO ##users SELECT 	535,'Школьник',11,'Б',''
547INSERT INTO ##users SELECT 	536,'Школьник',11,'Б',''
548INSERT INTO ##users SELECT 	537,'Школьник',11,'Б',''
549INSERT INTO ##users SELECT 	538,'Школьник',11,'Б',''
550INSERT INTO ##users SELECT 	539,'Школьник',11,'В',''
551INSERT INTO ##users SELECT 	540,'Школьник',11,'В',''
552INSERT INTO ##users SELECT 	541,'Школьник',11,'В',''
553INSERT INTO ##users SELECT 	542,'Родитель',NULL,'',''
554INSERT INTO ##users SELECT 	543,'Родитель',NULL,'',''
555INSERT INTO ##users SELECT 	544,'Родитель',NULL,'',''
556INSERT INTO ##users SELECT 	545,'Родитель',NULL,'',''
557INSERT INTO ##users SELECT 	546,'Родитель',NULL,'',''
558INSERT INTO ##users SELECT 	547,'Родитель',NULL,'',''
559INSERT INTO ##users SELECT 	548,'Родитель',NULL,'',''
560INSERT INTO ##users SELECT 	549,'Родитель',NULL,'',''
561INSERT INTO ##users SELECT 	550,'Родитель',NULL,'',''
562INSERT INTO ##users SELECT 	551,'Родитель',NULL,'',''
563INSERT INTO ##users SELECT 	552,'Родитель',NULL,'',''
564INSERT INTO ##users SELECT 	553,'Родитель',NULL,'',''
565INSERT INTO ##users SELECT 	554,'Родитель',NULL,'',''
566INSERT INTO ##users SELECT 	555,'Родитель',NULL,'',''
567INSERT INTO ##users SELECT 	556,'Родитель',NULL,'',''
568INSERT INTO ##users SELECT 	557,'Родитель',NULL,'',''
569INSERT INTO ##users SELECT 	558,'Родитель',NULL,'',''
570INSERT INTO ##users SELECT 	559,'Родитель',NULL,'',''
571INSERT INTO ##users SELECT 	560,'Родитель',NULL,'',''
572INSERT INTO ##users SELECT 	561,'Родитель',NULL,'',''
573INSERT INTO ##users SELECT 	562,'Родитель',NULL,'',''
574INSERT INTO ##users SELECT 	563,'Родитель',NULL,'',''
575INSERT INTO ##users SELECT 	564,'Родитель',NULL,'',''
576INSERT INTO ##users SELECT 	558,'Родитель',NULL,'',''
577INSERT INTO ##users SELECT 	559,'Родитель',NULL,'',''
578INSERT INTO ##users SELECT 	560,'Родитель',NULL,'',''
579INSERT INTO ##users SELECT 	561,'Родитель',NULL,'',''
580INSERT INTO ##users SELECT 	562,'Родитель',NULL,'',''
581INSERT INTO ##users SELECT 	563,'Родитель',NULL,'',''
582INSERT INTO ##users SELECT 	564,'Родитель',NULL,'',''
583
584
585INSERT INTO ##check SELECT	1,1,10,'Г'
586INSERT INTO ##check SELECT	2,1,8,'А'
587INSERT INTO ##check SELECT	3,1,10,'Г'
588INSERT INTO ##check SELECT	4,1,5,'Б'
589INSERT INTO ##check SELECT	5,2,11,'А'
590INSERT INTO ##check SELECT	6,2,9,'А'
591INSERT INTO ##check SELECT	7,2,8,'А'
592INSERT INTO ##check SELECT	8,3,6,'В'
593INSERT INTO ##check SELECT	9,3,8,'А'
594INSERT INTO ##check SELECT	10,3,10,'В'
595INSERT INTO ##check SELECT	11,4,8,'А'
596INSERT INTO ##check SELECT	12,4,8,'В'
597INSERT INTO ##check SELECT	13,4,8,'А'
598INSERT INTO ##check SELECT	14,4,10,'А'
599INSERT INTO ##check SELECT	15,5,5,'Б'
600INSERT INTO ##check SELECT	16,5,6,'Б'
601INSERT INTO ##check SELECT	17,5,6,'А'
602INSERT INTO ##check SELECT	18,5,5,'А'
603INSERT INTO ##check SELECT	19,5,8,'В'
604INSERT INTO ##check SELECT	20,5,5,'Б'
605INSERT INTO ##check SELECT	21,6,8,'Е'
606INSERT INTO ##check SELECT	22,7,8,'Г'
607INSERT INTO ##check SELECT	23,7,8,'Б'
608INSERT INTO ##check SELECT	24,7,9,'А'
609INSERT INTO ##check SELECT	25,8,8,'В'
610INSERT INTO ##check SELECT	26,8,5,'А'
611INSERT INTO ##check SELECT	27,8,7,'А'
612INSERT INTO ##check SELECT	28,8,11,'А'
613INSERT INTO ##check SELECT	29,8,7,'Б'
614INSERT INTO ##check SELECT	30,9,5,'Б'
615INSERT INTO ##check SELECT	31,9,5,'А'
616INSERT INTO ##check SELECT	32,9,6,'А'
617INSERT INTO ##check SELECT	33,9,8,'А'
618INSERT INTO ##check SELECT	34,9,5,'А'
619INSERT INTO ##check SELECT	35,9,11,'Б'
620INSERT INTO ##check SELECT	36,9,5,'Б'
621INSERT INTO ##check SELECT	37,9,11,'В'
622INSERT INTO ##check SELECT	38,10,5,'Б'
623INSERT INTO ##check SELECT	39,10,11,'Б'
624INSERT INTO ##check SELECT	40,10,8,'В'
625INSERT INTO ##check SELECT	41,10,6,'А'
626INSERT INTO ##check SELECT	42,10,11,'В'
627INSERT INTO ##check SELECT	43,11,6,'Б'
628INSERT INTO ##check SELECT	44,13,5,'А'
629INSERT INTO ##check SELECT	45,13,7,'А'
630INSERT INTO ##check SELECT	46,14,11,'А'
631INSERT INTO ##check SELECT	47,14,8,'Б'
632INSERT INTO ##check SELECT	48,14,5,'Б'
633INSERT INTO ##check SELECT	49,15,11,'Б'
634INSERT INTO ##check SELECT	50,16,10,'А'
635INSERT INTO ##check SELECT	51,17,11,'А'
636INSERT INTO ##check SELECT	52,18,6,'А'
637INSERT INTO ##check SELECT	53,18,7,'А'
638INSERT INTO ##check SELECT	54,18,7,'А'
639INSERT INTO ##check SELECT	55,18,8,'А'
640INSERT INTO ##check SELECT	56,18,5,'А'
641INSERT INTO ##check SELECT	57,21,5,'Б'
642INSERT INTO ##check SELECT	58,21,8,'В'
643INSERT INTO ##check SELECT	59,22,7,'Б'
644INSERT INTO ##check SELECT	60,22,5,'А'
645INSERT INTO ##check SELECT	61,22,9,'А'
646INSERT INTO ##check SELECT	62,23,8,'Б'
647INSERT INTO ##check SELECT	63,23,5,'А'
648INSERT INTO ##check SELECT	64,23,6,'Б'
649INSERT INTO ##check SELECT	65,23,7,'А'
650INSERT INTO ##check SELECT	66,24,6,'А'
651INSERT INTO ##check SELECT	67,24,8,'В'
652INSERT INTO ##check SELECT	68,24,8,'Б'
653INSERT INTO ##check SELECT	69,24,11,'Б'
654INSERT INTO ##check SELECT	70,25,5,'Б'
655INSERT INTO ##check SELECT	71,25,8,'В'
656INSERT INTO ##check SELECT	72,25,8,'А'
657INSERT INTO ##check SELECT	73,25,5,'Б'
658INSERT INTO ##check SELECT	74,25,10,'А'
659INSERT INTO ##check SELECT	75,25,6,'А'
660INSERT INTO ##check SELECT	76,25,10,'А'
661INSERT INTO ##check SELECT	77,25,8,'Г'
662INSERT INTO ##check SELECT	78,25,5,'А'
663INSERT INTO ##check SELECT	79,25,9,'А'
664INSERT INTO ##check SELECT	80,25,7,'Б'
665INSERT INTO ##check SELECT	81,25,6,'А'
666INSERT INTO ##check SELECT	82,26,5,'Б'
667INSERT INTO ##check SELECT	83,26,8,'Б'
668INSERT INTO ##check SELECT	84,26,11,'А'
669INSERT INTO ##check SELECT	85,26,6,'А'
670INSERT INTO ##check SELECT	86,26,11,'А'
671INSERT INTO ##check SELECT	87,26,8,'А'
672INSERT INTO ##check SELECT	88,26,6,'А'
673INSERT INTO ##check SELECT	89,26,11,'А'
674INSERT INTO ##check SELECT	90,26,8,'Б'
675INSERT INTO ##check SELECT	91,26,11,'В'
676INSERT INTO ##check SELECT	92,26,11,'В'
677INSERT INTO ##check SELECT	93,27,6,'А'
678INSERT INTO ##check SELECT	94,28,11,'В'
679INSERT INTO ##check SELECT	95,28,9,'А'
680INSERT INTO ##check SELECT	96,28,11,'В'
681INSERT INTO ##check SELECT	97,28,6,'А'
682INSERT INTO ##check SELECT	98,28,5,'А'
683INSERT INTO ##check SELECT	99,28,8,'Б'
684INSERT INTO ##check SELECT	100,28,11,'В'
685INSERT INTO ##check SELECT	101,28,6,'В'
686INSERT INTO ##check SELECT	102,28,11,'В'
687INSERT INTO ##check SELECT	103,28,8,'А'
688INSERT INTO ##check SELECT	104,28,6,'А'
689INSERT INTO ##check SELECT	105,28,11,'В'
690INSERT INTO ##check SELECT	106,28,7,'Б'
691INSERT INTO ##check SELECT	107,28,10,'А'
692INSERT INTO ##check SELECT	108,28,5,'Б'
693INSERT INTO ##check SELECT	109,28,11,'А'
694INSERT INTO ##check SELECT	110,28,7,'А'
695INSERT INTO ##check SELECT	111,28,5,'А'
696INSERT INTO ##check SELECT	112,29,9,'А'
697INSERT INTO ##check SELECT	113,29,6,'В'
698INSERT INTO ##check SELECT	114,29,10,'А'
699INSERT INTO ##check SELECT	115,29,8,'Б'
700INSERT INTO ##check SELECT	116,29,5,'А'
701INSERT INTO ##check SELECT	117,29,10,'А'
702INSERT INTO ##check SELECT	118,29,6,'А'
703INSERT INTO ##check SELECT	119,29,11,'Б'
704INSERT INTO ##check SELECT	120,30,8,'Б'
705INSERT INTO ##check SELECT	121,30,6,'В'
706INSERT INTO ##check SELECT	122,33,6,'А'
707INSERT INTO ##check SELECT	123,33,11,'В'
708INSERT INTO ##check SELECT	124,33,8,'А'
709INSERT INTO ##check SELECT	125,33,6,'А'
710INSERT INTO ##check SELECT	126,33,6,'А'
711INSERT INTO ##check SELECT	127,33,6,'Б'
712INSERT INTO ##check SELECT	128,33,11,'Б'
713INSERT INTO ##check SELECT	129,33,5,'Б'
714INSERT INTO ##check SELECT	130,34,9,'А'
715INSERT INTO ##check SELECT	131,34,6,'В'
716INSERT INTO ##check SELECT	132,34,9,'А'
717INSERT INTO ##check SELECT	133,34,7,'Б'
718INSERT INTO ##check SELECT	134,34,5,'Б'
719INSERT INTO ##check SELECT	135,34,8,'Е'
720INSERT INTO ##check SELECT	136,35,7,'А'
721INSERT INTO ##check SELECT	137,35,10,'А'
722INSERT INTO ##check SELECT	138,35,8,'Б'
723INSERT INTO ##check SELECT	139,35,6,'А'
724INSERT INTO ##check SELECT	140,35,11,'А'
725INSERT INTO ##check SELECT	141,35,5,'Б'
726INSERT INTO ##check SELECT	142,35,8,'Б'
727INSERT INTO ##check SELECT	143,36,8,'А'
728INSERT INTO ##check SELECT	144,40,5,'Б'
729INSERT INTO ##check SELECT	145,40,11,'В'
730INSERT INTO ##check SELECT	146,40,6,'В'
731INSERT INTO ##check SELECT	147,40,5,'А'
732INSERT INTO ##check SELECT	148,40,8,'Б'
733INSERT INTO ##check SELECT	149,40,6,'Б'
734INSERT INTO ##check SELECT	150,40,8,'Б'
735INSERT INTO ##check SELECT	151,40,8,'Г'
736INSERT INTO ##check SELECT	152,40,6,'А'
737INSERT INTO ##check SELECT	153,40,9,'А'
738INSERT INTO ##check SELECT	154,40,7,'А'
739INSERT INTO ##check SELECT	155,41,8,'Б'
740INSERT INTO ##check SELECT	156,42,5,'А'
741INSERT INTO ##check SELECT	157,42,5,'Б'
742INSERT INTO ##check SELECT	158,42,11,'Б'
743INSERT INTO ##check SELECT	159,43,7,'Б'
744INSERT INTO ##check SELECT	160,43,5,'Б'
745INSERT INTO ##check SELECT	161,43,11,'В'
746INSERT INTO ##check SELECT	162,43,6,'В'
747INSERT INTO ##check SELECT	163,43,10,'А'
748INSERT INTO ##check SELECT	164,43,6,'А'
749INSERT INTO ##check SELECT	165,43,10,'А'
750INSERT INTO ##check SELECT	166,43,8,'Б'
751INSERT INTO ##check SELECT	167,43,5,'А'
752INSERT INTO ##check SELECT	168,44,9,'А'
753INSERT INTO ##check SELECT	169,44,8,'А'
754INSERT INTO ##check SELECT	170,44,7,'Б'
755INSERT INTO ##check SELECT	171,44,11,'А'
756INSERT INTO ##check SELECT	172,44,9,'А'
757INSERT INTO ##check SELECT	173,44,5,'Б'
758INSERT INTO ##check SELECT	174,45,9,'Б'
759INSERT INTO ##check SELECT	175,45,6,'В'
760INSERT INTO ##check SELECT	176,45,11,'В'
761INSERT INTO ##check SELECT	177,45,6,'Б'
762INSERT INTO ##check SELECT	178,45,8,'Г'
763INSERT INTO ##check SELECT	179,46,8,'Б'
764INSERT INTO ##check SELECT	180,46,5,'А'
765INSERT INTO ##check SELECT	181,46,8,'Б'
766INSERT INTO ##check SELECT	182,46,11,'Б'
767INSERT INTO ##check SELECT	183,46,8,'А'
768INSERT INTO ##check SELECT	184,46,11,'Б'
769INSERT INTO ##check SELECT	185,46,6,'А'
770INSERT INTO ##check SELECT	186,46,6,'В'
771INSERT INTO ##check SELECT	187,46,11,'А'
772INSERT INTO ##check SELECT	188,46,5,'А'
773INSERT INTO ##check SELECT	189,48,10,'А'
774INSERT INTO ##check SELECT	190,48,7,'Б'
775INSERT INTO ##check SELECT	191,48,8,'Б'
776INSERT INTO ##check SELECT	192,48,5,'А'
777INSERT INTO ##check SELECT	193,48,8,'Е'
778INSERT INTO ##check SELECT	194,48,8,'Б'
779INSERT INTO ##check SELECT	195,48,6,'Б'
780INSERT INTO ##check SELECT	196,48,11,'А'
781INSERT INTO ##check SELECT	197,49,8,'Г'
782INSERT INTO ##check SELECT	198,49,5,'А'
783INSERT INTO ##check SELECT	199,49,8,'А'
784INSERT INTO ##check SELECT	200,50,5,'Б'
785INSERT INTO ##check SELECT	NULL,NULL,NULL,''
786INSERT INTO ##check SELECT	NULL,NULL,NULL,''
787INSERT INTO ##check SELECT	NULL,NULL,NULL,''
788INSERT INTO ##check SELECT	NULL,NULL,NULL,''
789INSERT INTO ##check SELECT	NULL,NULL,NULL,''
790INSERT INTO ##check SELECT	NULL,NULL,NULL,''
791INSERT INTO ##check SELECT	NULL,NULL,NULL,''
792INSERT INTO ##check SELECT	NULL,NULL,NULL,''
793INSERT INTO ##check SELECT	NULL,NULL,NULL,''
794INSERT INTO ##check SELECT	NULL,NULL,NULL,''
795INSERT INTO ##check SELECT	NULL,NULL,NULL,''
796INSERT INTO ##check SELECT	NULL,NULL,NULL,''
797INSERT INTO ##check SELECT	NULL,NULL,NULL,''
798INSERT INTO ##check SELECT	NULL,NULL,NULL,''
799INSERT INTO ##check SELECT	NULL,NULL,NULL,''
800INSERT INTO ##check SELECT	NULL,NULL,NULL,''
801INSERT INTO ##check SELECT	NULL,NULL,NULL,''
802INSERT INTO ##check SELECT	NULL,NULL,NULL,''
803INSERT INTO ##check SELECT	NULL,NULL,NULL,''
804INSERT INTO ##check SELECT	NULL,NULL,NULL,''
805INSERT INTO ##check SELECT	NULL,NULL,NULL,''
806INSERT INTO ##check SELECT	NULL,NULL,NULL,''
807INSERT INTO ##check SELECT	NULL,NULL,NULL,''
808INSERT INTO ##check SELECT	NULL,NULL,NULL,''
809INSERT INTO ##check SELECT	NULL,NULL,NULL,''
810INSERT INTO ##check SELECT	NULL,NULL,NULL,''
811INSERT INTO ##check SELECT	NULL,NULL,NULL,''
812INSERT INTO ##check SELECT	NULL,NULL,NULL,''
813INSERT INTO ##check SELECT	NULL,NULL,NULL,''
814INSERT INTO ##check SELECT	NULL,NULL,NULL,''
815INSERT INTO ##check SELECT	NULL,NULL,NULL,''
816INSERT INTO ##check SELECT	NULL,NULL,NULL,''
817INSERT INTO ##check SELECT	NULL,NULL,NULL,''
818INSERT INTO ##check SELECT	NULL,NULL,NULL,''
819INSERT INTO ##check SELECT	NULL,NULL,NULL,''
820INSERT INTO ##check SELECT	NULL,NULL,NULL,''
821INSERT INTO ##check SELECT	NULL,NULL,NULL,''
822INSERT INTO ##check SELECT	NULL,NULL,NULL,''
823INSERT INTO ##check SELECT	NULL,NULL,NULL,''
824INSERT INTO ##check SELECT	NULL,NULL,NULL,''
825INSERT INTO ##check SELECT	NULL,NULL,NULL,''
826INSERT INTO ##check SELECT	NULL,NULL,NULL,''
827INSERT INTO ##check SELECT	NULL,NULL,NULL,''
828INSERT INTO ##check SELECT	NULL,NULL,NULL,''
829INSERT INTO ##check SELECT	NULL,NULL,NULL,''
830INSERT INTO ##check SELECT	NULL,NULL,NULL,''
831INSERT INTO ##check SELECT	NULL,NULL,NULL,''
832INSERT INTO ##check SELECT	NULL,NULL,NULL,''
833INSERT INTO ##check SELECT	NULL,NULL,NULL,''
834INSERT INTO ##check SELECT	NULL,NULL,NULL,''
835INSERT INTO ##check SELECT	NULL,NULL,NULL,''
836INSERT INTO ##check SELECT	NULL,NULL,NULL,''
837INSERT INTO ##check SELECT	NULL,NULL,NULL,''
838INSERT INTO ##check SELECT	NULL,NULL,NULL,''
839INSERT INTO ##check SELECT	NULL,NULL,NULL,''
840INSERT INTO ##check SELECT	NULL,NULL,NULL,''
841INSERT INTO ##check SELECT	NULL,NULL,NULL,''
842INSERT INTO ##check SELECT	NULL,NULL,NULL,''
843INSERT INTO ##check SELECT	NULL,NULL,NULL,''
844INSERT INTO ##check SELECT	NULL,NULL,NULL,''
845INSERT INTO ##check SELECT	NULL,NULL,NULL,''
846INSERT INTO ##check SELECT	NULL,NULL,NULL,''
847INSERT INTO ##check SELECT	NULL,NULL,NULL,''
848INSERT INTO ##check SELECT	NULL,NULL,NULL,''
849INSERT INTO ##check SELECT	NULL,NULL,NULL,''
850INSERT INTO ##check SELECT	NULL,NULL,NULL,''
851INSERT INTO ##check SELECT	NULL,NULL,NULL,''
852INSERT INTO ##check SELECT	NULL,NULL,NULL,''
853INSERT INTO ##check SELECT	NULL,NULL,NULL,''
854INSERT INTO ##check SELECT	NULL,NULL,NULL,''
855INSERT INTO ##check SELECT	NULL,NULL,NULL,''
856INSERT INTO ##check SELECT	NULL,NULL,NULL,''
857INSERT INTO ##check SELECT	NULL,NULL,NULL,''
858INSERT INTO ##check SELECT	NULL,NULL,NULL,''
859INSERT INTO ##check SELECT	NULL,NULL,NULL,''
860INSERT INTO ##check SELECT	NULL,NULL,NULL,''
861INSERT INTO ##check SELECT	NULL,NULL,NULL,''
862INSERT INTO ##check SELECT	NULL,NULL,NULL,''
863INSERT INTO ##check SELECT	NULL,NULL,NULL,''
864INSERT INTO ##check SELECT	NULL,NULL,NULL,''
865INSERT INTO ##check SELECT	NULL,NULL,NULL,''
866INSERT INTO ##check SELECT	NULL,NULL,NULL,''
867INSERT INTO ##check SELECT	NULL,NULL,NULL,''
868INSERT INTO ##check SELECT	NULL,NULL,NULL,''
869INSERT INTO ##check SELECT	NULL,NULL,NULL,''
870INSERT INTO ##check SELECT	NULL,NULL,NULL,''
871INSERT INTO ##check SELECT	NULL,NULL,NULL,''
872INSERT INTO ##check SELECT	NULL,NULL,NULL,''
873INSERT INTO ##check SELECT	NULL,NULL,NULL,''
874INSERT INTO ##check SELECT	NULL,NULL,NULL,''
875INSERT INTO ##check SELECT	NULL,NULL,NULL,''
876INSERT INTO ##check SELECT	NULL,NULL,NULL,''
877INSERT INTO ##check SELECT	NULL,NULL,NULL,''
878INSERT INTO ##check SELECT	NULL,NULL,NULL,''
879INSERT INTO ##check SELECT	NULL,NULL,NULL,''
880INSERT INTO ##check SELECT	NULL,NULL,NULL,''
881INSERT INTO ##check SELECT	NULL,NULL,NULL,''
882INSERT INTO ##check SELECT	NULL,NULL,NULL,''
883INSERT INTO ##check SELECT	NULL,NULL,NULL,''
884INSERT INTO ##check SELECT	NULL,NULL,NULL,''
885INSERT INTO ##check SELECT	NULL,NULL,NULL,''
886INSERT INTO ##check SELECT	NULL,NULL,NULL,''
887INSERT INTO ##check SELECT	NULL,NULL,NULL,''
888INSERT INTO ##check SELECT	NULL,NULL,NULL,''
889INSERT INTO ##check SELECT	NULL,NULL,NULL,''
890INSERT INTO ##check SELECT	NULL,NULL,NULL,''
891INSERT INTO ##check SELECT	NULL,NULL,NULL,''
892INSERT INTO ##check SELECT	NULL,NULL,NULL,''
893INSERT INTO ##check SELECT	NULL,NULL,NULL,''
894INSERT INTO ##check SELECT	NULL,NULL,NULL,''
895INSERT INTO ##check SELECT	NULL,NULL,NULL,''
896INSERT INTO ##check SELECT	NULL,NULL,NULL,''
897INSERT INTO ##check SELECT	NULL,NULL,NULL,''
898INSERT INTO ##check SELECT	NULL,NULL,NULL,''
899INSERT INTO ##check SELECT	NULL,NULL,NULL,''
900INSERT INTO ##check SELECT	NULL,NULL,NULL,''
901INSERT INTO ##check SELECT	NULL,NULL,NULL,''
902INSERT INTO ##check SELECT	NULL,NULL,NULL,''
903INSERT INTO ##check SELECT	NULL,NULL,NULL,''
904INSERT INTO ##check SELECT	NULL,NULL,NULL,''
905INSERT INTO ##check SELECT	NULL,NULL,NULL,''
906INSERT INTO ##check SELECT	NULL,NULL,NULL,''
907INSERT INTO ##check SELECT	NULL,NULL,NULL,''
908INSERT INTO ##check SELECT	NULL,NULL,NULL,''
909INSERT INTO ##check SELECT	NULL,NULL,NULL,''
910INSERT INTO ##check SELECT	NULL,NULL,NULL,''
911INSERT INTO ##check SELECT	NULL,NULL,NULL,''
912INSERT INTO ##check SELECT	NULL,NULL,NULL,''
913INSERT INTO ##check SELECT	NULL,NULL,NULL,''
914INSERT INTO ##check SELECT	NULL,NULL,NULL,''
915INSERT INTO ##check SELECT	NULL,NULL,NULL,''
916INSERT INTO ##check SELECT	NULL,NULL,NULL,''
917INSERT INTO ##check SELECT	NULL,NULL,NULL,''
918INSERT INTO ##check SELECT	NULL,NULL,NULL,''
919INSERT INTO ##check SELECT	NULL,NULL,NULL,''
920INSERT INTO ##check SELECT	NULL,NULL,NULL,''
921INSERT INTO ##check SELECT	NULL,NULL,NULL,''
922INSERT INTO ##check SELECT	NULL,NULL,NULL,''
923INSERT INTO ##check SELECT	NULL,NULL,NULL,''
924INSERT INTO ##check SELECT	NULL,NULL,NULL,''
925INSERT INTO ##check SELECT	NULL,NULL,NULL,''
926INSERT INTO ##check SELECT	NULL,NULL,NULL,''
927INSERT INTO ##check SELECT	NULL,NULL,NULL,''
928INSERT INTO ##check SELECT	NULL,NULL,NULL,''
929INSERT INTO ##check SELECT	NULL,NULL,NULL,''
930INSERT INTO ##check SELECT	NULL,NULL,NULL,''
931INSERT INTO ##check SELECT	NULL,NULL,NULL,''
932INSERT INTO ##check SELECT	NULL,NULL,NULL,''
933INSERT INTO ##check SELECT	NULL,NULL,NULL,''
934INSERT INTO ##check SELECT	NULL,NULL,NULL,''
935INSERT INTO ##check SELECT	NULL,NULL,NULL,''
936INSERT INTO ##check SELECT	NULL,NULL,NULL,''
937INSERT INTO ##check SELECT	NULL,NULL,NULL,''
938INSERT INTO ##check SELECT	NULL,NULL,NULL,''
939INSERT INTO ##check SELECT	NULL,NULL,NULL,''
940INSERT INTO ##check SELECT	NULL,NULL,NULL,''
941INSERT INTO ##check SELECT	NULL,NULL,NULL,''
942INSERT INTO ##check SELECT	NULL,NULL,NULL,''
943INSERT INTO ##check SELECT	NULL,NULL,NULL,''
944INSERT INTO ##check SELECT	NULL,NULL,NULL,''
945INSERT INTO ##check SELECT	NULL,NULL,NULL,''
946INSERT INTO ##check SELECT	NULL,NULL,NULL,''
947INSERT INTO ##check SELECT	NULL,NULL,NULL,''
948INSERT INTO ##check SELECT	NULL,NULL,NULL,''
949INSERT INTO ##check SELECT	NULL,NULL,NULL,''
950INSERT INTO ##check SELECT	NULL,NULL,NULL,''
951INSERT INTO ##check SELECT	NULL,NULL,NULL,''
952INSERT INTO ##check SELECT	NULL,NULL,NULL,''
953INSERT INTO ##check SELECT	NULL,NULL,NULL,''
954INSERT INTO ##check SELECT	NULL,NULL,NULL,''
955INSERT INTO ##check SELECT	NULL,NULL,NULL,''
956INSERT INTO ##check SELECT	NULL,NULL,NULL,''
957INSERT INTO ##check SELECT	NULL,NULL,NULL,''
958INSERT INTO ##check SELECT	NULL,NULL,NULL,''
959INSERT INTO ##check SELECT	NULL,NULL,NULL,''
960INSERT INTO ##check SELECT	NULL,NULL,NULL,''
961INSERT INTO ##check SELECT	NULL,NULL,NULL,''
962INSERT INTO ##check SELECT	NULL,NULL,NULL,''
963INSERT INTO ##check SELECT	NULL,NULL,NULL,''
964INSERT INTO ##check SELECT	NULL,NULL,NULL,''
965INSERT INTO ##check SELECT	NULL,NULL,NULL,''
966INSERT INTO ##check SELECT	NULL,NULL,NULL,''
967INSERT INTO ##check SELECT	NULL,NULL,NULL,''
968INSERT INTO ##check SELECT	NULL,NULL,NULL,''
969INSERT INTO ##check SELECT	NULL,NULL,NULL,''
970INSERT INTO ##check SELECT	NULL,NULL,NULL,''
971INSERT INTO ##check SELECT	NULL,NULL,NULL,''
972INSERT INTO ##check SELECT	NULL,NULL,NULL,''
973INSERT INTO ##check SELECT	NULL,NULL,NULL,''
974INSERT INTO ##check SELECT	NULL,NULL,NULL,''
975INSERT INTO ##check SELECT	NULL,NULL,NULL,''
976INSERT INTO ##check SELECT	NULL,NULL,NULL,''
977INSERT INTO ##check SELECT	NULL,NULL,NULL,''
978INSERT INTO ##check SELECT	NULL,NULL,NULL,''
979INSERT INTO ##check SELECT	NULL,NULL,NULL,''
980INSERT INTO ##check SELECT	NULL,NULL,NULL,''
981INSERT INTO ##check SELECT	NULL,NULL,NULL,''
982INSERT INTO ##check SELECT	NULL,NULL,NULL,''
983INSERT INTO ##check SELECT	NULL,NULL,NULL,''
984INSERT INTO ##check SELECT	NULL,NULL,NULL,''
985INSERT INTO ##check SELECT	NULL,NULL,NULL,''
986INSERT INTO ##check SELECT	NULL,NULL,NULL,''
987INSERT INTO ##check SELECT	NULL,NULL,NULL,''
988INSERT INTO ##check SELECT	NULL,NULL,NULL,''
989INSERT INTO ##check SELECT	NULL,NULL,NULL,''
990INSERT INTO ##check SELECT	NULL,NULL,NULL,''
991INSERT INTO ##check SELECT	NULL,NULL,NULL,''
992INSERT INTO ##check SELECT	NULL,NULL,NULL,''
993INSERT INTO ##check SELECT	NULL,NULL,NULL,''
994INSERT INTO ##check SELECT	NULL,NULL,NULL,''
995INSERT INTO ##check SELECT	NULL,NULL,NULL,''
996INSERT INTO ##check SELECT	NULL,NULL,NULL,''
997INSERT INTO ##check SELECT	NULL,NULL,NULL,''
998INSERT INTO ##check SELECT	NULL,NULL,NULL,''
999INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1000INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1001INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1002INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1003INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1004INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1005INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1006INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1007INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1008INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1009INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1010INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1011INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1012INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1013INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1014INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1015INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1016INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1017INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1018INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1019INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1020INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1021INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1022INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1023INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1024INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1025INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1026INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1027INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1028INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1029INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1030INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1031INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1032INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1033INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1034INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1035INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1036INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1037INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1038INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1039INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1040INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1041INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1042INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1043INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1044INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1045INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1046INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1047INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1048INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1049INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1050INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1051INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1052INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1053INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1054INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1055INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1056INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1057INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1058INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1059INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1060INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1061INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1062INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1063INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1064INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1065INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1066INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1067INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1068INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1069INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1070INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1071INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1072INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1073INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1074INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1075INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1076INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1077INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1078INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1079INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1080INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1081INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1082INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1083INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1084INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1085INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1086INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1087INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1088INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1089INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1090INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1091INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1092INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1093INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1094INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1095INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1096INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1097INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1098INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1099INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1100INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1101INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1102INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1103INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1104INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1105INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1106INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1107INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1108INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1109INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1110INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1111INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1112INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1113INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1114INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1115INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1116INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1117INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1118INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1119INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1120INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1121INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1122INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1123INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1124INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1125INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1126INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1127INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1128INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1129INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1130INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1131INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1132INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1133INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1134INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1135INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1136INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1137INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1138INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1139INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1140INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1141INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1142INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1143INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1144INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1145INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1146INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1147INSERT INTO ##check SELECT	NULL,NULL,NULL,''
1148INSERT INTO ##check SELECT	NULL,NULL,NULL,'';
1149
1150
1151
1152
1153WITH pupils AS (
1154	SELECT -- количество учеников в каждом классе
1155		class
1156		, letter
1157		, count (*) pupils
1158	FROM ##users
1159	WHERE role = 'Школьник'
1160	GROUP BY class, letter
1161	) , 
1162
1163teachers AS (
1164SELECT DISTINCT -- классы, в которые учитель выдавал хоть одно задание
1165	teacher_id
1166	, class
1167	, letter
1168FROM ##check 
1169WHERE teacher_id IS NOT NULL
1170	) ,
1171
1172list AS ( -- список искомых учителей (у которых суммарное количество учеников в классах учителя более 30)
1173SELECT t.teacher_id, SUM(p.pupils) cnt
1174FROM teachers t
1175JOIN pupils p
1176	ON t.class = p.class
1177	AND t.letter = p.letter
1178GROUP BY t.teacher_id
1179HAVING SUM(p.pupils) > 30
1180	)
1181
1182SELECT COUNT (*) teachers_cnt
1183FROM list