ػѹѺ ­ҧ ʾ. ࢵ 40 (ྪúó) [ ʾ.ྪúó 3]
ç¹ ͧ ͧ ͧ Թ ͧᴧ
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=3 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 ˹ͧ 47 24 14 85 88 15 7 4 110
2 ֧ѹԷҤ 36 13 9 58 66 12 5 5 83
3 Ż͹ó 16 17 6 39 41 15 10 5 66
4 ෾Ъä 10 12 7 29 34 14 3 9 51
5 ʹԷҤ 9 5 4 18 21 11 6 7 38
6 ⤡çԷҤ 8 4 4 16 25 13 6 4 44
7 ѧԡžԷҤ 7 12 14 33 38 11 8 7 57
8 شԷ 7 4 4 15 21 7 4 2 32
9 آرط 5 11 8 24 32 17 9 4 58
10 §ԷҤ 5 3 5 13 18 12 8 6 38
11 ྪФԷ 4 8 7 19 29 14 2 3 45
12 ͧ෾ 4 5 8 17 26 22 9 9 57
13 ѺóԷҤ 4 2 4 10 11 6 7 7 24
14 ͷʹ֡ 2 2 2 6 7 5 6 5 18
15 ŴԷҹó 2 1 3 6 8 5 7 1 20
16 ྪúó 2 0 1 3 3 4 5 3 12
17 Ѻ͹ԷҤ 1 6 2 9 13 8 10 6 31
18 ҴǧԷҤ 1 3 3 7 5 11 4 4 20
19 ѹԷ 1 3 2 6 8 8 8 6 24
20 ҹѧ 1 2 2 5 6 5 3 1 14
21 حѡҹó 1 2 0 3 4 2 3 3 9
22 ૹѹԾѲ 1 1 0 2 5 9 5 6 19
23 ԷҤ 1 1 0 2 4 10 5 4 19
24 Էҹ֡ 1 0 2 3 1 5 5 3 11
25 ѧ˭ԷҤ 0 3 4 7 13 18 9 6 40
26 žѹԷ 0 2 0 2 2 3 2 2 7
27 ͹ԷҤ 0 1 2 3 8 8 4 4 20
28 ⪵Է 0 1 0 1 1 5 3 3 9
29 ͹غžԵ 0 0 2 2 1 3 9 4 13
30 ѲԷ 0 0 1 1 1 2 5 1 8
31 лѵԸἹѭ֡ ЪҹԵ 0 0 0 0 1 3 6 1 10
176 148 120 444 541 283 183 135 1,007