02 SQL запросы
.pdf31. , , ,
, 300 32. , , ,
,
33., , , ,
, 10
34. , |
|
, 200
35., , ,
, « »
36., , ,
,
37. , ,
38. ,
39. ,
40. ,
41. ,
42. ,
43. ,
44. ,
,
45., ,
, 10
11
46. , ,
10 47. , ,
1000 48. , ,
, 15 49. , ,
20 50. ,
, , 5
12
6
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
1. |
Medic |
1 |
13 |
30 |
51 |
57 |
68 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2. |
Post |
1 |
7 |
18 |
25 |
35 |
48 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3. |
Taxi |
7 |
8 |
19 |
29 |
37 |
45 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4. |
Medic |
2 |
14 |
31 |
50 |
58 |
69 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5. |
Medic |
3 |
15 |
32 |
49 |
59 |
70 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6. |
Post |
2 |
8 |
19 |
26 |
36 |
49 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7. |
Taxi |
6 |
9 |
20 |
30 |
38 |
46 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8. |
Medic |
4 |
16 |
33 |
48 |
60 |
71 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9. |
Medic |
5 |
17 |
34 |
47 |
61 |
72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10. |
Post |
3 |
9 |
20 |
27 |
37 |
50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11. |
Taxi |
5 |
10 |
21 |
31 |
39 |
47 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12. |
Medic |
6 |
18 |
35 |
46 |
62 |
73 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13. |
Medic |
7 |
19 |
36 |
45 |
63 |
74 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
14. |
Medic |
8 |
20 |
37 |
44 |
64 |
75 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15. |
Medic |
9 |
21 |
38 |
43 |
65 |
76 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
16. |
Medic |
10 |
22 |
39 |
42 |
66 |
77 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
17. |
Medic |
11 |
23 |
40 |
41 |
67 |
78 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
18. |
Post |
4 |
10 |
21 |
28 |
38 |
51 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
19. |
Taxi |
4 |
11 |
22 |
32 |
40 |
48 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
20. |
Medic |
12 |
24 |
30 |
41 |
52 |
79 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
21. |
Taxi |
3 |
12 |
23 |
33 |
41 |
49 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
22. |
Medic |
1 |
25 |
35 |
47 |
53 |
80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
23. |
Post |
5 |
11 |
22 |
29 |
39 |
52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
24. |
Medic |
2 |
26 |
31 |
42 |
54 |
81 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
25. |
Medic |
3 |
27 |
32 |
43 |
55 |
68 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
26. |
Post |
6 |
12 |
23 |
30 |
40 |
50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13
7
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
1. |
medic |
4 |
28 |
33 |
44 |
52 |
69 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2. |
post |
1 |
13 |
24 |
31 |
41 |
53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3. |
medic |
5 |
29 |
34 |
45 |
53 |
70 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4. |
taxi |
2 |
13 |
24 |
34 |
42 |
45 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5. |
medic |
6 |
13 |
35 |
46 |
54 |
71 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6. |
post |
2 |
14 |
18 |
32 |
42 |
54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7. |
medic |
7 |
14 |
36 |
47 |
55 |
72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8. |
taxi |
1 |
14 |
25 |
35 |
43 |
46 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9. |
medic |
8 |
15 |
37 |
48 |
56 |
73 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10. |
post |
3 |
15 |
19 |
33 |
43 |
48 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11. |
medic |
9 |
16 |
38 |
49 |
57 |
74 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12. |
taxi |
7 |
15 |
26 |
36 |
44 |
47 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13. |
medic |
10 |
17 |
39 |
50 |
58 |
75 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
14. |
post |
4 |
16 |
20 |
34 |
44 |
49 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15. |
medic |
11 |
18 |
40 |
51 |
59 |
76 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
16. |
taxi |
6 |
16 |
27 |
29 |
37 |
48 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
17. |
medic |
12 |
19 |
30 |
42 |
60 |
77 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
18. |
taxi |
5 |
17 |
28 |
30 |
38 |
49 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
19. |
medic |
1 |
20 |
31 |
43 |
61 |
78 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
14
8
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
1. |
medic |
2 |
21 |
32 |
44 |
62 |
80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2. |
medic |
3 |
22 |
33 |
45 |
63 |
81 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3. |
post |
5 |
17 |
21 |
25 |
45 |
50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4. |
taxi |
4 |
18 |
19 |
31 |
39 |
50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5. |
medic |
4 |
23 |
34 |
46 |
64 |
68 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6. |
medic |
5 |
24 |
35 |
47 |
65 |
69 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7. |
post |
6 |
7 |
22 |
26 |
46 |
51 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8. |
taxi |
3 |
8 |
20 |
32 |
40 |
45 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9. |
medic |
6 |
25 |
36 |
48 |
66 |
70 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10. |
medic |
7 |
26 |
37 |
49 |
67 |
71 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11. |
post |
1 |
8 |
23 |
27 |
47 |
52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12. |
taxi |
2 |
9 |
21 |
33 |
41 |
46 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13. |
medic |
8 |
27 |
38 |
50 |
52 |
72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
14. |
medic |
9 |
28 |
39 |
51 |
53 |
73 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15. |
post |
2 |
9 |
24 |
28 |
35 |
53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
16. |
taxi |
1 |
10 |
22 |
34 |
42 |
47 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
17. |
medic |
10 |
29 |
40 |
43 |
54 |
74 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
18. |
medic |
11 |
13 |
30 |
44 |
55 |
75 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
19. |
medic |
12 |
14 |
31 |
45 |
57 |
78 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
20. |
taxi |
7 |
11 |
23 |
35 |
44 |
48 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
21. |
medic |
1 |
15 |
32 |
46 |
56 |
76 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
22. |
post |
3 |
10 |
18 |
29 |
36 |
54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
23. |
taxi |
6 |
12 |
24 |
36 |
37 |
49 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15