ػѹѺ ­ҧ ʾ. ࢵ 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=74 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 صôԵس 52 38 9 99 97 10 3 6 110
2 صôԵ 48 30 13 91 91 11 4 4 106
3 Ԫ 38 21 19 78 83 13 5 3 101
4 ԭԷ 7 7 12 26 30 12 4 4 46
5 ҹ⤹Է 7 1 5 13 21 7 5 4 33
6 ش֡ҹ صôԵ 6 12 12 30 33 25 6 2 64
7 ѺԷ 4 2 3 9 15 17 5 7 37
8 ͧʹѹԷ 3 9 8 20 31 12 5 12 48
9 ԴԷ 3 8 11 22 33 21 10 7 64
10 ͹Թ 3 7 9 19 28 18 7 7 53
11 ҹѹԷҤ 2 4 6 12 21 18 6 4 45
12 ԹԷҤ 2 3 6 11 17 5 0 3 22
13 觡Է 2 1 0 3 11 7 2 5 20
14 Ҵҹó 1 4 3 8 10 4 9 3 23
15 ѺžԷҤ 1 3 5 9 23 8 3 4 34
16 ѧоԷҤ 0 3 1 4 11 4 2 2 17
17 ҾԷҤ 0 1 3 4 8 3 3 4 14
18 ʹԷ 0 1 0 1 4 4 5 5 13
19 ҸԵԷҪѯصôԵ 0 0 1 1 4 4 2 1 10
179 155 126 460 571 203 86 87 860