ػѹѺ ­ҧ ʾ. ࢵ 5 (ԧ,ž,¹ҷ,ҧͧ) [ ʾ.ž 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=51 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 ԺԷ 34 13 4 51 53 5 0 1 58
2 ҹԷ 32 17 10 59 60 17 9 6 86
3 óҪԷ ž 20 26 15 61 62 15 9 5 86
4 й³ 16 16 9 41 41 16 6 10 63
5 ⤡Է 11 12 3 26 30 14 7 14 51
6 ⤡Է 10 4 4 18 21 10 3 7 34
7 ԹԵ֡Ҫٻ 8 5 5 18 21 5 3 4 29
8 ҹԷ 8 5 3 16 21 11 2 10 34
9 кص 6 6 9 21 24 15 9 8 48
10 ԷҤ 6 6 8 20 35 16 9 12 60
11 ⤡çԷ 5 6 12 23 26 20 11 12 57
12 ҹԡԷҤ 5 3 2 10 15 7 3 5 25
13 ѭ͹ǹ ž 4 4 4 12 13 12 4 4 29
14 ¹³֡ 3 5 3 11 9 8 4 5 21
15 ҹԷ 3 1 4 8 8 4 1 3 13
16 ҸԵԷҪѯ෾ʵ 2 8 6 16 17 4 1 2 22
17 Է 2 1 7 10 21 12 6 14 39
18 Ѳ 0 1 1 2 2 2 2 1 6
19 0 0 5 5 7 8 1 4 16
175 139 114 428 486 201 90 127 777