ػѹѺ ­ҧ ʾ. ࢵ 38 (⢷,ҡ) [ ʾ.⢷ 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=65 AND im_school.area_type_id=2 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 ä͹ѹԷ 48 25 22 95 117 7 3 1 127
2 çٻ 32 32 15 79 89 15 1 3 105
3 ٻ 22 26 15 63 70 12 2 2 84
4 ͧ§ 15 15 17 47 59 6 7 3 72
5 չ 15 14 12 41 52 11 6 1 69
6 ҹԷҤ 10 10 4 24 29 10 3 3 42
7 žԷ 8 4 9 21 41 9 6 1 56
8 Ⱥͧäš 6 3 5 14 22 13 7 2 42
9 ä͹ѹԷ 2 6 2 2 10 15 6 6 1 27
10 ˹ͧѺԷҤ 5 2 2 9 13 6 1 0 20
11 ȺäšЪä 5 0 0 5 7 0 0 0 7
12 ҹԷ 4 3 6 13 25 14 6 4 45
13 ˹ͧԷҤ 4 3 3 10 19 7 9 2 35
14 ͧԷ 2 6 3 11 15 11 7 2 33
15 ѧͧԷ 1 1 2 4 13 3 4 2 20
16 ķ 1 1 1 3 4 0 0 0 4
17 ҪԷ 0 5 3 8 20 10 6 2 36
18 عþԷҤ 0 4 0 4 7 6 5 1 18
19 Ѵ˹ͧԷ 0 0 0 0 1 2 0 0 3
184 156 121 461 618 148 79 30 845