·Õè
ࢵ¾×é¹·Õè¡ÒÃÈÖ¡ÉÒ
ª¹ÐàÅÔÈ
Ãͧ ñ
Ãͧ ò
ÃÇÁ
·Í§
à§Ô¹
·Í§á´§
à¢éÒÃèÇÁ
ÃÇÁ
SELECT im_school.area_type_id AS area_type_id,im_school.province_id AS province_id, im_school.zone_num AS zone_num, im_school.area_sm AS area_sm, 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_team.confirm_status=1 AND im_school.school_id=im_team.school_id GROUP BY im_school.province_id, im_school.zone_num , im_school.area_sm ORDER BY winner DESC, two_rank DESC, three_rank DESC, gold_medal DESC, silver_medal DESC,bronze_medal DESC,join_medal DESC, NUB DESC
1
ʾ». ¾ÐàÂÒ à¢µ 2
2
1
0
3
4
1
2
1
7
2
ʾ». ÍصôԵ¶ì ࢵ 1
2
1
0
3
4
1
2
0
7
3
ʾ». ¡Óᾧྪà ࢵ 1
1
2
1
4
6
0
2
0
8
4
ʾ». àªÕ§ÃÒ ࢵ 3
1
0
1
2
4
1
1
1
6
5
ʾ». ÍØ·ÑÂ¸Ò¹Õ à¢µ 2
1
0
0
1
2
4
1
0
7
6
ʾ». ÅÓ»Ò§ ࢵ 1
1
0
0
1
1
1
0
0
2
7
ʾ». ÊØ⢷Ñ ࢵ 2
0
2
0
2
3
1
2
0
6
8
ʾ». ¡Óᾧྪà ࢵ 2
0
1
0
1
4
2
1
0
7
9
ʾ». ¹¤ÃÊÇÃäì ࢵ 2
0
1
0
1
2
2
1
1
5
10
ʾ». ¹èÒ¹ ࢵ 2
0
0
2
2
3
2
3
0
8
11
ʾ». àªÕ§ãËÁè ࢵ 3
0
0
1
1
4
1
3
0
8
12
ʾ». ÅÓ¾Ù¹ ࢵ 1
0
0
1
1
3
0
3
1
6
13
ʾ». ¹èÒ¹ ࢵ 1
0
0
1
1
2
1
3
1
6
14
ʾ». àªÕ§ÃÒ ࢵ 2
0
0
1
1
2
1
0
0
3
15
ʾ». àªÕ§ãËÁè ࢵ 5
0
0
0
0
2
1
4
1
7
16
ʾ». ¾Ô¨ÔµÃ ࢵ 1
0
0
0
0
2
1
3
2
6
17
ʾ». ÍصôԵ¶ì ࢵ 2
0
0
0
0
1
2
2
0
5
18
ʾ». àªÕ§ãËÁè ࢵ 2
0
0
0
0
1
2
1
0
4
19
ʾ». ÅÓ¾Ù¹ ࢵ 2
0
0
0
0
1
2
0
0
3
20
ʾ». ¾ÐàÂÒ à¢µ 1
0
0
0
0
1
1
2
0
4
21
ʾ». µÒ¡ ࢵ 1
0
0
0
0
1
1
0
0
2
22
ʾ». á¾Ãè ࢵ 2
0
0
0
0
1
0
0
0
1
23
ʾ». ¾ÔɳØâÅ¡ ࢵ 3
0
0
0
0
0
4
2
2
6
24
ʾ». µÒ¡ ࢵ 2
0
0
0
0
0
4
0
2
4
25
ʾ». ¾ÔɳØâÅ¡ ࢵ 2
0
0
0
0
0
2
4
0
6
26
ʾ». àªÕ§ãËÁè ࢵ 6
0
0
0
0
0
2
2
1
4
27
ʾ». ྪúÙóì ࢵ 2
0
0
0
0
0
1
5
0
6
28
ʾ». ¹¤ÃÊÇÃäì ࢵ 3
0
0
0
0
0
1
4
2
5
29
ʾ». àªÕ§ÃÒ ࢵ 4
0
0
0
0
0
1
0
0
1
30
ʾ». ÅÓ»Ò§ ࢵ 2
0
0
0
0
0
0
3
0
3
ÃÇÁ
8
8
8
24
54
43
56
15
153