ػѹѺ ­ҧ ʾ. ࢵ 39 (ɳš,صôԵ) [ ʾ.ɳš 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=37 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 ѭʵ 55 30 12 97 91 12 5 0 108
2 ҹͧ 37 16 7 60 66 17 7 9 90
3 ɳšԷҤ 22 21 22 65 54 21 7 3 82
4 ش֡ Ҥ˹ 10 8 7 25 26 9 4 2 39
5 طԹҪԷ 9 8 12 29 29 22 8 9 59
6 ҧСԷ֡ 9 5 6 20 28 9 8 8 45
7 óҪԷ ɳš 8 12 9 29 32 13 6 2 51
8 ѸҸԵԷ¹ 6 8 2 16 15 4 1 2 20
9 5 9 1 15 17 6 7 7 30
10 اɮ 3 3 9 15 15 11 5 4 31
11 ͧúǹѧѴɳš 3 2 1 6 4 4 2 3 10
12 ʧʧ شäѡػ 2 5 1 8 10 10 14 6 34
13 ЪʧԷ 2 2 5 9 12 11 6 7 29
14 ͹ͧԷ 2 2 0 4 5 5 1 3 11
15 ҹҧԷҤ 2 0 2 4 5 3 5 2 13
16 ҷͧԷҤ 1 2 0 3 8 11 4 10 23
17 ѧӤ֡ 1 1 3 5 5 7 4 7 16
18 ҹѡô 0 0 1 1 1 0 1 0 2
177 134 100 411 423 175 95 84 693