ػѹѺ ­ҧ ʾ. ࢵ 40 (ྪúó) [ ʾ.ྪúó 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=39 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 ԷҹءŹ 59 23 5 87 87 11 2 4 100
2 ྪþԷҤ 31 20 13 64 70 9 1 2 80
3 ֡ 12 22 17 51 51 16 8 7 75
4 ૹ૿ྪúó 11 21 20 52 55 13 7 6 75
5 ҪЪҹ ѧѴྪúó 11 5 7 23 29 7 5 5 41
6 ԷҤ 9 12 11 32 36 8 9 6 53
7 Ѫê 7 1 0 8 15 9 3 6 27
8 Ⱥ ҭԷ 5 4 1 10 14 2 4 2 20
9 ᴹԷҤ 3 10 6 19 26 15 7 9 48
10 ͧúǹѧѴྪúó(ѧԷҤ) 3 5 8 16 20 13 8 8 41
11 ǹҺԷ ྪúó 3 1 7 11 18 5 3 8 26
12 ྪúóԷ 2 3 7 12 14 9 9 11 32
13 ѧ֡ 2 1 2 5 11 4 6 6 21
14 ѧ觾ԷҤ 1 6 7 14 14 6 4 5 24
15 ԹԷҤ 1 1 3 5 5 4 5 3 14
16 ԵԾԷ 1 0 0 1 4 0 1 2 5
17 ҹó 0 1 2 3 5 2 4 2 11
18 ҭɮԷ 0 0 0 0 2 2 1 4 5
19 ૹժᴹ 0 0 0 0 2 2 1 0 5
161 136 116 413 478 137 88 96 703