ػѹѺ ­ҧ ʾ. ࢵ 10 (ྪú,ШǺբѹ,طʧ,طҤ) [ ʾ.طҤ 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=61 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 طҤԷ 39 21 17 77 69 21 9 7 99
2 зẹطس 20 26 22 68 56 23 9 9 88
3 طҤúó 20 21 11 52 48 18 6 7 72
4 ٻ 15 15 8 38 36 15 14 8 65
5 õ طҤ 13 8 6 27 28 18 5 10 51
6 طҤزԪ 10 7 6 23 26 10 5 10 41
7 ȺźҹҪ 10 4 0 14 14 0 0 2 14
8 Ѵ 8 7 5 20 21 12 8 9 41
9 Ѵҧ (ɮا) 5 8 12 25 26 13 8 10 47
10 ҹԷ(赧) 5 0 2 7 8 3 3 8 14
11 ѹ¹ԧԷ 4 4 2 10 10 12 13 14 35
12 ͹ó 3 3 2 8 5 14 6 8 25
13 ֡ 2 6 5 13 9 15 4 8 28
14 ЪԹó 2 6 1 9 8 8 7 5 23
15 ѴѡԾѲɮػ 2 2 2 6 10 10 11 20 31
16 ѡͧԷ 2 0 3 5 4 3 3 7 10
17 ҹͧ 0 2 0 2 2 1 0 0 3
18 ҹѹ 0 1 0 1 1 1 3 4 5
19 ѭ ѡٵѧ 0 1 0 1 1 1 0 0 2
20 Է 0 0 0 0 2 7 4 11 13
21 ҹ෤ 0 0 0 0 1 4 1 5 6
160 142 104 406 385 209 119 162 713