ػѹѺ ­ҧ ʾ. ࢵ 37 (,ҹ) [ ʾ. 1]
ç¹ ͧ ͧ ͧ Թ ͧᴧ
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=40 AND im_school.area_type_id=2 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 ѵѧѴ 54 30 11 95 97 8 4 3 109
2 ¨ѧѴ 40 40 17 97 96 11 4 2 111
3 ͧԷҤ 23 9 14 46 47 8 7 5 62
4 ͧҧ͹ó 13 17 22 52 50 16 10 7 76
5 ǧԷҤ 10 10 7 27 36 18 15 7 69
6 ෾ԷѡԷ 8 4 6 18 20 13 10 6 43
7 ԭɮ 8 4 4 16 20 7 7 6 34
8 ԷҤ 7 7 10 24 27 9 7 6 43
9 ͧ 7 5 6 18 17 13 7 6 37
10 ҪЪҹ 25 3 9 5 17 19 9 4 6 32
11 Է 2 6 5 13 19 12 10 5 41
12 §෾Է 2 3 4 9 13 24 12 6 49
13 ҸԵȺźҹવѹ 2 1 2 5 5 1 0 1 6
14 ૹѧ 1 3 6 10 11 8 11 7 30
15 ҢԷҤ 1 0 1 2 1 3 1 0 5
16 ѲһЪػ 0 2 2 4 4 5 1 5 10
17 طԷ 0 0 0 0 0 0 0 1 0
181 150 122 453 482 165 110 79 757