ػѹѺ ­ҧ ʾ. ࢵ 13 (ѧ,к)
ç¹ ͧ ͧ ͧ Թ ͧᴧ
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=15 AND im_school.area_type_id=2 AND im_school.zone_num=13 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 31 17 89 74 15 7 7 96
2 ҪԹ ѧѴѧ 33 19 19 71 71 22 12 9 105
3 ѹѧԷҡ 25 17 13 55 45 20 10 9 75
4 ó֡ 23 26 11 60 69 10 8 2 87
5 22 25 11 58 41 34 15 9 90
6 ҵ 19 22 18 59 74 18 5 9 97
7 ҹҢѰٻ 18 12 13 43 43 26 12 11 81
8 ɮ 11 11 16 38 28 23 10 15 61
9 һЪҼاԷ 10 4 9 23 23 9 10 18 42
10 ѧ 9 10 16 35 25 17 8 13 50
11 ɮҹػдɰ͹ó 9 7 4 20 19 15 6 16 40
12 ѸѴǹŹԸ 9 5 6 20 27 16 8 10 51
13 óҪԷ ѧ 8 8 4 20 22 10 4 2 36
14 ¹ҧɮا 8 4 1 13 12 13 7 9 32
15 ҪԹ 2 7 10 13 30 37 21 6 14 64
16 ѧԷ 7 4 4 15 21 17 17 17 55
17 ¹ا 6 6 13 25 31 22 10 13 63
18 Ѥ֡ 6 6 5 17 13 21 6 20 40
19 ʴѵآ 6 3 5 14 17 22 12 10 51
20 ԡ 6 1 3 10 15 13 4 5 32
21 Ⱥ 2 (ѴоѧԹ) 5 4 3 12 16 11 6 15 33
22 ҧԷҤ 5 3 7 15 14 13 7 12 34
23 ҴҭԷҤ 4 7 3 14 10 17 13 9 40
24 ѹѧɮ֡ 4 6 12 22 15 21 17 12 53
25 ЪԷ 4 5 4 13 13 12 9 10 34
26 3 6 5 14 23 10 5 0 38
27 ҵ 2 3 5 1 9 9 11 3 4 23
28 ѧ¹֡ 3 4 2 9 18 13 7 12 38
29 Ӽش 3 2 2 7 14 12 10 2 36
30 ҵ 3 3 0 4 7 11 20 12 6 43
31 ѭԷ 2 8 6 16 24 27 9 6 60
32 ˹ͧ駻Ъä 2 7 8 17 17 17 10 22 44
33 ѧѧɮ 2 3 3 8 14 10 9 12 33
34 §ԷҤ 2 3 0 5 13 12 6 13 31
35 ҾԷҤ 2 1 2 5 4 5 15 10 24
36 ͧԷ 1 4 3 8 6 11 10 11 27
37 ҹҵٻ 1 2 0 3 3 4 4 10 11
38 ѹԷҤ 1 1 6 8 11 7 10 3 28
39 Ǽا 1 1 1 3 6 10 8 8 24
40 ԾѵԷ 1 0 0 1 1 4 0 2 5
41 Ѵԡѧɮ 0 0 0 0 0 1 4 0 5
335 303 273 911 949 612 351 397 1,912