ػѹѺ ­ҧ ʾ. ࢵ 35 (ӻҧ,Ӿٹ)
ç¹ ͧ ͧ ͧ Թ ͧᴧ
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=53 AND im_school.area_type_id=2 AND im_school.zone_num=35 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 ѡäӤҷ ѧѴӾٹ 63 30 12 105 109 11 2 0 122
2 §਴Է 54 26 11 91 80 12 3 1 95
3 áҹҹ 53 32 15 100 88 20 3 1 111
4 ǹح⭻ Ӿٹ 47 37 20 104 95 24 5 1 124
5 ҪЪҹ 26 24 17 14 55 58 18 11 9 87
6 ׹Է 18 28 26 72 49 27 9 2 85
7 ǪҧԷҤ 14 19 12 45 33 18 7 4 58
8 Ǫûҫҧ 11 11 15 37 41 24 10 1 75
9 ҷԷҤ 9 7 8 24 19 17 9 0 45
10 ӴԺԷҤ 8 16 20 44 49 22 15 0 86
11 ҫҧ 8 7 16 31 26 30 15 2 71
12 ԷҤ 8 7 8 23 28 25 8 5 61
13 ҹ鹾ԷҤ 4 9 6 19 25 16 14 1 55
14 лѵԸЪǧҾѲ 4 2 3 9 6 7 5 1 18
15 ԷҤ 3 3 1 7 11 13 11 2 35
16 ҢԹԷҤ 2 9 8 19 21 21 19 0 61
17 õ 2 7 5 14 15 12 10 1 37
18 ҵźҹԾԷ 1 2 4 7 10 17 12 3 39
19 Է 0 7 4 11 13 8 5 1 26
20 ҹѵԷ 0 6 6 12 6 16 9 4 31
21 ѵԷ 0 1 2 3 3 2 1 1 6
22 ˨ԵԷ 0 1 1 2 1 8 8 1 17
23 лѵԸѴиҵҴǧ 0 0 1 1 2 3 2 2 7
24 زԡ 0 0 0 0 1 0 1 0 2
25 ҸԵ֡ 0 0 0 0 0 0 3 0 3
333 284 218 835 789 371 197 43 1,357