ػѹѺ ­ҧ ʾ. ԧ
ç¹ ͧ ͧ ͧ Թ ͧᴧ
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=64 AND im_school.area_type_id=1 AND im_school.zone_num=1 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 ͹غԧ 20 5 5 30 35 5 4 1 44
2 Թջзҹ 13 13 10 36 38 16 10 5 64
3 Ѵǧ 11 7 9 27 18 9 5 9 32
4 ҹ˹ͧԷҤ 8 6 5 19 16 4 0 1 20
5 ѴѧҪ 8 2 5 15 19 6 8 6 33
6 Ⱥ Ѵ⾸ǹس 8 2 0 10 10 2 0 0 12
7 Ѵ 6 4 6 16 16 3 1 2 20
8 ѴдѺ 6 4 3 13 12 7 3 3 22
9 ͹غȺ (Ե) 6 1 3 10 11 4 2 0 17
10 ѴҤ 5 7 3 15 20 2 3 7 25
11 Ѵ§ҡ 5 4 1 10 10 1 4 1 15
12 ѴԷ 4 5 2 11 12 4 1 1 17
13 Ѵѹ 4 1 2 7 3 6 3 8 12
14 Ѵҹ 3 7 2 12 12 5 4 13 21
15 Ѵʶ (Թ) 3 5 5 13 15 11 4 3 30
16 ѴҧҢ 3 5 1 9 9 5 2 3 16
17 ѴлҧԷ 3 1 5 9 4 10 4 4 18
18 ѴԷԼ 3 1 1 5 9 8 3 4 20
19 Ѵ 3 1 0 4 4 2 2 2 8
20 Ѵ 3 1 0 4 4 1 0 0 5
21 Ѵѡ 3 0 1 4 4 1 1 2 6
22 Ѵҧԭآ 3 0 0 3 4 3 2 2 9
23 ѰԷ (ҹ˹ͧз) 2 5 2 9 8 2 2 3 12
24 ԨԵ֡ 2 5 1 8 8 12 13 7 33
25 Ѵй͹ѡ ԵҾ 133 2 4 2 8 8 1 0 4 9
26 ͹غźҧШѹ 2 2 4 8 9 4 2 4 15
27 Էҹó 2 2 3 7 11 9 13 5 33
28 Ѵ⪵ԡ 2 2 1 5 4 1 0 0 5
29 Ѵ 2 2 0 4 6 2 3 0 11
30 ͧപЪҹ 2 1 3 6 4 3 1 0 8
31 Ѵͧ 2 1 2 5 2 5 6 6 13
32 ͹غͧԧ 2 1 1 4 4 0 3 4 7
33 Ѵҹ(͹ó) 2 0 1 3 3 2 3 1 8
34 Ѵҧ 2 0 1 3 3 1 2 0 6
35 Ѵ԰ 2 0 0 2 3 8 3 0 14
36 Ѵ֡Ҫ 2 0 0 2 3 0 0 0 3
37 Ѵ 1 6 1 8 7 4 2 5 13
38 Ѵҧٹ 1 5 1 7 7 4 2 7 13
39 Ѵлҧع 1 2 1 4 5 2 0 2 7
40 Ѵ⾸ 1 2 1 4 5 1 0 2 6
41 ѴҹѺ 1 2 0 3 6 1 1 1 8
42 Ѵԧ 1 2 0 3 2 3 1 1 6
43 ͹غŷҪҧ 1 1 3 5 2 9 2 0 13
44 ѴҴ⾸ 1 1 3 5 1 4 0 2 5
45 Ѵ͹ 1 1 1 3 4 5 2 1 11
46 Ѵҧ 1 1 1 3 2 2 0 1 4
47 Ѵҧ 1 1 0 2 3 8 5 5 16
48 Ѵ͢ 1 1 0 2 3 1 2 1 6
49 Ѵ 1 1 0 2 2 2 0 1 4
50 Ѵ⾸ 1 1 0 2 2 1 1 0 4
51 С« ԧ 1 1 0 2 1 2 5 3 8
52 ͹غŤºҧШѹ 1 0 3 4 4 6 0 1 10
53 ͹غԹ (Ѵ⾸) 1 0 2 3 3 5 5 1 13
54 ѴҪ 1 0 1 2 5 2 1 2 8
55 Ѵ˹ͧ 1 0 1 2 3 4 5 3 12
56 Ѵҧ 1 0 1 2 3 3 1 1 7
57 ѴɮԷ 1 0 1 2 2 5 4 1 11
58 ѴҴɮا 1 0 1 2 2 4 4 2 10
59 Ѵ 1 0 1 2 2 2 1 3 5
60 Ѵѹٵ 1 0 0 1 3 2 4 1 9
61 Ѵ⾸ѧ 1 0 0 1 2 0 1 0 3
62 Ѵ⤻ٹ 1 0 0 1 2 0 0 0 2
63 Ѵ 1 0 0 1 1 4 1 2 6
64 Ѵ⾸ 1 0 0 1 1 1 2 1 4
65 ҹҧҭ 1 0 0 1 1 1 2 0 4
66 Ѵ͹਴ 1 0 0 1 1 0 0 1 1
67 Ѵԧ 0 5 1 6 3 7 3 1 13
68 ѴҸء 0 4 1 5 2 5 1 0 8
69 Ѵ¹ҧ˧ 0 3 0 3 3 1 0 1 4
70 Ѵ 0 2 2 4 1 1 2 1 4
71 Ѵй 0 2 0 2 3 1 0 0 4
72 Ѵ⾸Ѥ 0 1 4 5 5 4 2 4 11
73 Ѵʶ (Ҫҧ) 0 1 3 4 1 7 0 0 8
74 Ѵ෾ 0 1 2 3 5 1 0 0 6
75 Ѵҧ 0 1 2 3 0 3 3 4 6
76 شѾ 0 1 1 2 3 2 0 0 5
77 Ѵй͹ 0 1 1 2 3 1 0 0 4
78 ѴҸԹ 0 1 1 2 2 1 4 1 7
79 Ⱥ ɮԷ 0 1 0 1 3 3 6 3 12
80 Ѵ⤡ 0 1 0 1 2 0 1 0 3
81 ѴѤո 0 1 0 1 1 0 0 2 1
82 Ѵ⾸ҭ (Ҵ) 0 1 0 1 1 0 0 0 1
83 Ѵͧ 0 1 0 1 0 1 0 2 1
84 ѴҤ 0 0 3 3 1 2 3 2 6
85 Ѵдѧ 0 0 1 1 2 2 0 1 4
86 Ѵ 0 0 1 1 1 2 1 0 4
87 ѴԷԤسҡ 0 0 1 1 1 1 1 0 3
88 ѴҸͧ (ͧ) 0 0 1 1 1 1 0 3 2
89 Ѵͧ⾸ 0 0 1 1 1 0 1 0 2
90 Ѵ 0 0 1 1 1 0 0 3 1
91 Ҥдɰ 0 0 1 1 1 0 0 0 1
92 ͹غž 0 0 1 1 0 4 2 2 6
93 ѴҪ 0 0 1 1 0 0 1 2 1
94 ҹ 0 0 0 0 2 3 0 0 5
95 Ѵعʧ 0 0 0 0 2 1 1 0 4
96 ҹ觡Ѻ 0 0 0 0 2 0 2 1 4
97 ȺŷѺ(Ѵط) 0 0 0 0 1 3 1 1 5
98 Ѵ෾ 0 0 0 0 1 2 1 4 4
99 ѴҧԹ 0 0 0 0 1 1 1 3 3
100 Ѵз 0 0 0 0 1 0 0 3 1
101 Ѵͧ 0 0 0 0 1 0 0 0 1
102 Ѵѧó 0 0 0 0 0 2 2 3 4
103 Ѵ 0 0 0 0 0 1 2 2 3
104 Ѵ(ԵҾ 183) 0 0 0 0 0 1 1 0 2
105 ѴӼ 0 0 0 0 0 1 0 2 1
106 Ѵء 0 0 0 0 0 1 0 1 1
107 Ѵâ 0 0 0 0 0 1 0 0 1
108 Ѵҷ 0 0 0 0 0 0 2 0 2
109 Ѵǧ 0 0 0 0 0 0 1 1 1
110 ҷԷ 0 0 0 0 0 0 1 0 1
111 Ѵ˹ 0 0 0 0 0 0 1 0 1
112 Ѵ⾸͹ 0 0 0 0 0 0 0 1 0
113 Ѵ͡ 0 0 0 0 0 0 0 0 0
114 ѤԷ 0 0 0 0 0 0 0 0 0
115 Ѵԡŷͧ 0 0 0 0 0 0 0 0 0
116 ѴѧШѺ 0 0 0 0 0 0 0 0 0
189 163 143 495 506 320 218 216 1,044