ػѹѺ ­ҧ ʾ. ҹ ࢵ 2
ç¹ ͧ ͧ ͧ Թ ͧᴧ
SELECT im_school.school_id AS s_id,im_school.school_name AS s_name, COUNT(*) AS NUB , COUNT(IF(im_team.award='ͧ',award,NULL)) AS gold_medal, COUNT(IF(im_team.award='Թ',award,NULL)) AS silver_medal, COUNT(IF(im_team.award='ͧᴧ',award,NULL)) AS bronze_medal, COUNT(IF(im_team.award='',award,NULL)) AS join_medal, COUNT(IF(im_team.rank='',rank,NULL)) AS winner, COUNT(IF(im_team.rank='ͧѹѺ ',rank,NULL)) AS two_rank, COUNT(IF(im_team.rank='ͧѹѺ ',rank,NULL)) AS three_rank FROM im_school,im_team WHERE im_school.province_id=28 AND im_school.area_type_id=1 AND im_school.zone_num=2 AND im_team.confirm_status=1 AND im_school.school_id=im_team.school_id GROUP BY im_team.school_id ORDER BY winner DESC, two_rank DESC, three_rank DESC, gold_medal DESC, silver_medal DESC,bronze_medal DESC,join_medal DESC, NUB DESC, s_name ASC
1 Ѵԡ 34 11 7 52 58 13 7 13 78
2 Ѵʧä 22 12 8 42 46 16 13 15 75
3 ѭԷŻ 20 10 5 35 37 20 4 3 61
4 ѴҴʹ 19 21 13 53 48 25 16 15 89
5 ȾԹԨԷҤ 13 13 13 39 31 17 16 22 64
6 Ѵͧѹ 13 13 8 34 29 18 18 17 65
7 ըԵ 8 5 5 18 22 9 5 9 36
8 ҴѧԵ 8 3 8 19 23 12 12 9 47
9 ѴԪԵԵ 7 7 3 17 15 10 14 20 39
10 Ѵ 6 2 1 9 10 10 12 9 32
11 ͧԷ 5 6 6 17 17 15 14 8 46
12 ԭԷ 5 3 1 9 15 8 5 11 28
13 ºԷ 5 3 1 9 12 7 2 8 21
14 ʹѧԵ 5 3 0 8 7 1 1 2 9
15 ЪҸԻѵԷҤ 5 1 2 8 15 6 6 10 27
16 Ѵسʵ 4 6 7 17 10 16 8 17 34
17 Ѵѧ 4 3 0 7 8 3 5 12 16
18 Ѵѭԡ 4 2 1 7 7 6 12 10 25
19 Ѵ͹˭ 4 1 1 6 12 5 2 1 19
20 Ѵ¹ࢵ 3 12 7 22 28 18 11 10 57
21 ЪҹԡӹǷ 3 2 2 7 6 1 4 2 11
22 ѳԵ (ԺóŻ֡) 3 2 1 6 6 8 5 3 19
23 ֧ 2 3 2 7 9 6 6 10 21
24 ѭ͹ó 2 2 0 4 3 1 0 0 4
25 Ѵɯѷ 2 1 2 5 8 4 7 12 19
26 Ѵó 2 1 1 4 3 6 0 3 9
27 Ѵȹ 2 1 0 3 4 4 14 6 22
28 ⪤ѧԵ 1 5 1 7 9 3 2 4 14
29 شԷ 1 3 3 7 9 10 12 7 31
30 Ъҹ 1 1 4 6 5 6 2 3 13
31 ѴҺح 1 1 3 5 5 10 5 9 20
32 ѴؾԸ 1 1 3 5 2 4 3 7 9
33 ҧͧԺ 1 1 1 3 9 8 7 11 24
34 ɮا 1 1 1 3 8 10 4 15 22
35 رѵԷ 1 1 0 2 6 3 4 13 13
36 ѴЪɮ 1 1 0 2 5 7 3 7 15
37 Ѵɮا 1 0 2 3 1 7 3 3 11
38 Ѵҧͧ 1 0 1 2 7 5 10 11 22
39 طǧ 1 0 0 1 3 7 7 14 17
40 ǹѡ 1 0 0 1 2 7 4 3 13
41 Ѵŷͧ 1 0 0 1 1 0 0 0 1
42 ѴŨԹ 0 5 5 10 8 11 12 11 31
43 0 3 1 4 4 6 6 8 16
44 Ѵ 0 3 0 3 7 3 7 8 17
45 Ѵѭм 0 2 1 3 5 2 3 2 10
46 Ѵø 0 1 4 5 8 8 8 6 24
47 Ѵʾԭ 0 1 2 3 5 11 14 10 30
48 ķ 0 1 2 3 5 7 5 14 17
49 ɮѤ 0 1 1 2 8 7 7 11 22
50 Ѵȷ 0 1 1 2 4 1 3 1 8
51 Ѵǧ 0 1 1 2 3 7 5 6 15
52 ѴҨԹ 0 1 1 2 2 3 1 2 6
53 Ѵآحԡ 0 1 0 1 2 2 4 2 8
54 Ѵɮúا 0 0 3 3 1 11 10 8 22
55 ͧط 0 0 1 1 8 7 8 12 23
56 ѧɮͧ 0 0 1 1 5 4 7 6 16
57 Ѵ¡ 0 0 1 1 3 5 7 4 15
58 Ѵ͹ԭ 0 0 1 1 3 3 12 3 18
59 Ѵࡵػ 0 0 1 1 1 1 4 6 6
60 Ѵʹ 0 0 1 1 1 1 0 0 2
61 ɮʧԷ 0 0 1 1 1 0 2 0 3
62 ѭԷ () 0 0 1 1 1 0 0 0 1
63 Ѵк 0 0 0 0 6 6 2 4 14
64 ŹԸԵѹԷ 0 0 0 0 3 5 7 8 15
65 ͧԺ "ɮا" 0 0 0 0 2 5 1 6 8
66 Ѵתش 0 0 0 0 2 3 4 3 9
67 Ѵ 0 0 0 0 2 1 1 0 4
68 ѴԹ 0 0 0 0 1 5 6 3 12
69 Ѵ½ 0 0 0 0 1 3 1 2 5
70 ҹѧͧѲ 0 0 0 0 1 2 2 4 5
71 ѴդѤҧ 0 0 0 0 1 1 0 1 2
72 ԡɮó 0 0 0 0 1 0 1 4 2
73 Եҷ 0 0 0 0 0 7 5 4 12
74 ʹ˹Է 0 0 0 0 0 5 3 4 8
75 Ѵѵ 0 0 0 0 0 4 6 6 10
76 èѡ 0 0 0 0 0 2 3 0 5
77 ҸԵ-ѵ Է෤ҪŸѭ 0 0 0 0 0 1 2 4 3
78 ǧ侱Է 0 0 0 0 0 0 0 2 0
79 ԾҡԷҡ 0 0 0 0 0 0 0 1 0
80 0 0 0 0 0 0 0 0 0
224 185 154 563 666 502 454 540 1,622