ػѹѺ ­ҧ ʾ. ࢵ 9 (ؾó,û) [ ʾ.û 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=19 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 ѴԧԷ 41 13 20 74 83 20 9 5 112
2 ҤԷ 37 16 14 67 80 18 6 2 104
3 ҭɡԷ û 35 25 15 75 79 13 4 3 96
4 ѷíҳԷ 17 12 7 36 48 24 10 8 82
5 ؤԷ 14 22 20 56 62 24 15 3 101
6 ... ҪԷ 㹾кҪٻ 8 4 5 17 19 15 12 1 46
7 ᫿ػ 6 20 17 43 55 23 7 4 85
8 ػ 5 3 4 12 22 13 10 5 45
9 ʡԷ 4 0 4 8 15 10 3 5 28
10 ҹԷ 3 16 10 29 43 16 16 5 75
11 ѵԹù 3 14 10 27 37 25 9 13 71
12 ºحѧɴ 3 4 1 8 12 3 7 4 22
13 ҧǧԷ 3 3 0 6 12 4 13 4 29
14 ѡح 2 1 1 4 14 9 8 11 31
15 մԷҤ 1 7 4 12 16 8 16 7 40
16 Է 1 4 1 6 13 10 5 0 28
17 ҧŹԷ 1 2 2 5 9 8 11 9 28
18 ǻҡԷ 1 2 1 4 10 7 8 9 25
19 غѵҪѭԷ û 1 0 3 4 6 5 11 3 22
20 Է 1 0 2 3 9 4 3 4 16
21 ອҾѲ 1 0 0 1 3 6 7 3 16
22 ʶҾԷ 0 2 3 5 14 12 8 8 34
23 ¹ 0 2 1 3 7 7 11 7 25
24 ¨ҵèԹ 0 0 3 3 6 7 9 4 22
188 172 148 508 674 291 218 127 1,183