ػѹѺ ­ҧ ʾ. ࢵ 3 (,йظ) [ ʾ.йظ 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=32 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 ʹ "ʹһԷ" 36 22 11 69 51 13 13 13 77
2 ҧԹ "Ҫҹ " 35 12 6 53 45 6 5 7 56
3 ҴǧèԷ 22 12 8 42 35 8 6 10 49
4 ҧԷ 21 12 11 44 35 16 5 9 56
5 ҴѤ 15 8 5 28 29 3 8 9 40
6 ҧԷ 8 16 6 30 26 12 6 9 44
7 ҧ 6 9 1 16 13 4 0 4 17
8 شԷ 5 7 5 17 8 8 11 6 27
9 ҤԷ 4 6 8 18 13 9 17 8 39
10 ѡ "طһآ" 4 6 5 15 13 12 4 11 29
11 ɮاŻ 4 5 3 12 6 7 7 6 20
12 ҪԷ 2 4 5 11 7 5 5 7 17
13 Ѵ⾸ѡ(Ǫѹ͹ó) 1 2 4 7 7 8 5 8 20
14 ૹ ѻʵ 1 2 3 6 1 2 4 0 7
15 ѴҤԭԷ 1 1 4 6 2 4 6 6 12
16 ҧԹ 1 1 1 3 5 6 7 7 18
17 ҴһЪҺا 0 1 0 1 0 1 2 3 3
18 ͡¸ 0 0 0 0 0 0 0 0 0
19 ૹëʧͧ 0 0 0 0 0 0 0 0 0
166 126 86 378 296 124 111 123 531