ػѹѺ ­ҧ ʾ. ࢵ 9 (ؾó,û) [ ʾ.ؾó 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=66 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 ʧǹ˭ԧ 49 24 10 83 81 7 2 3 90
2 óٵ֡ 34 30 21 85 75 18 13 0 106
3 ҭɡԷ ؾó 29 23 14 66 60 9 3 1 72
4 ҧ"٧üاԷ" 12 10 10 32 32 14 8 7 54
5 觪ѹԷ 10 10 10 30 30 15 8 8 53
6 ѧɮѤ 10 4 4 18 17 8 7 3 32
7 ջШѹ"ջآ" 6 13 7 26 20 11 15 9 46
8 بԵԷ 2 4 4 4 12 12 8 4 9 24
9 Է 4 2 3 9 9 4 3 2 16
10 ǹᵧԷ 3 4 6 13 18 10 11 5 39
11 ҧѰɮѧɴ 3 1 6 10 7 6 9 10 22
12 ԷøáԨ 2 2 5 9 12 6 2 4 20
13 ǧطԷ 0 3 3 6 10 6 5 6 21
166 130 103 399 383 122 90 67 595