ػѹѺ ­ҧ ʾ. ࢵ 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=19 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 ԹҪԷ 36 14 15 65 69 12 7 7 88
2 ҪԹպó 32 20 16 68 66 14 9 4 89
3 лԷ 25 15 11 51 55 18 3 5 76
4 ѸҹԹᾧʹ 15 13 19 47 50 28 12 16 90
5 ԪԷ 14 12 9 35 32 23 15 12 70
6 ͧԷ 10 25 25 60 61 27 13 11 101
7 Ѵ¨ԷҤ 9 15 10 34 34 21 10 17 65
8 ᾧʹԷ 9 6 8 23 26 16 11 5 53
9 çԷҤ 9 1 2 12 14 9 8 10 31
10 ⡾Էѡ 7 5 2 14 18 11 9 11 38
11 ҵ֡Է 7 1 5 13 17 13 7 9 37
12 ҸԵԷɵʵᾧʹ 4 8 8 20 18 7 7 10 32
13 лԷ 2 3 7 1 11 11 14 10 10 35
14 ҹǧԷ 3 3 1 7 11 8 11 9 30
15 ˺اԷ 2 5 2 9 12 5 8 12 25
16 اԷ 0 1 0 1 3 5 4 7 12
17 СԷҤ 0 0 3 3 4 5 5 5 14
18 ҸԵԷŻҡ 0 0 0 0 0 0 0 2 0
19 ʹȹû 0 0 0 0 0 0 0 1 0
185 151 137 473 501 236 149 163 886