·Õè
ࢵ¾×é¹·Õè¡ÒÃÈÖ¡ÉÒ
ª¹ÐàÅÔÈ
Ãͧ ñ
Ãͧ ò
ÃÇÁ
·Í§
à§Ô¹
·Í§á´§
à¢éÒÃèÇÁ
ÃÇÁ
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
0
0
2
2
0
1
1
3
2
ʾ». ÃÐÂͧ ࢵ 1
1
1
1
3
3
0
3
2
6
3
ʾ». ÊÁØ·ÃÊÒ¤Ã
1
0
1
2
2
0
0
5
2
4
ʾ». ¹¤Ã»°Á ࢵ 1
1
0
0
1
2
0
1
2
3
5
ʾ». ¡Ãا෾ÁËÒ¹¤Ã
1
0
0
1
1
1
0
4
2
6
ʾ». ¡Ò¨¹ºØÃÕ à¢µ 3
1
0
0
1
1
0
0
1
1
7
ʾ». ¡Ò¨¹ºØÃÕ à¢µ 2
1
0
0
1
0
4
3
1
7
8
ʾ». žºØÃÕ à¢µ 2
0
1
2
3
2
2
3
1
7
9
ʾ». ྪúØÃÕ à¢µ 1
0
1
1
2
2
1
0
1
3
10
ʾ». ÊÁطûÃÒ¡Òà ࢵ 1
0
1
0
1
2
2
0
2
4
11
ʾ». ¹¹·ºØÃÕ à¢µ 1
0
1
0
1
2
2
0
0
4
12
ʾ». ÊؾÃóºØÃÕ à¢µ 1
0
1
0
1
2
1
1
3
4
13
ʾ». ÃÒªºØÃÕ à¢µ 1
0
1
0
1
2
0
1
5
3
14
ʾ». ÍèÒ§·Í§
0
1
0
1
1
1
2
3
4
15
ʾ». »·ØÁ¸Ò¹Õ ࢵ 1
0
0
2
2
1
1
2
1
4
16
ʾ». žºØÃÕ à¢µ 1
0
0
1
1
2
3
1
2
6
17
ʾ». ¡Ò¨¹ºØÃÕ à¢µ 1
0
0
0
0
2
1
3
0
6
18
ʾ». ¨Ñ¹·ºØÃÕ à¢µ 1
0
0
0
0
1
1
3
3
5
19
ʾ». ÊÃÐá¡éÇ à¢µ 1
0
0
0
0
1
0
1
4
2
20
ʾ». ÊؾÃóºØÃÕ à¢µ 2
0
0
0
0
0
4
0
2
4
21
ʾ». ÊÃкØÃÕ à¢µ 2
0
0
0
0
0
3
3
2
6
22
ʾ». ¡Ò¨¹ºØÃÕ à¢µ 4
0
0
0
0
0
2
4
2
6
23
ʾ». ÃÒªºØÃÕ à¢µ 2
0
0
0
0
0
2
2
3
4
24
ʾ». µÃÒ´
0
0
0
0
0
2
2
1
4
25
ʾ». »·ØÁ¸Ò¹Õ ࢵ 2
0
0
0
0
0
2
1
3
3
26
ʾ». ÊؾÃóºØÃÕ à¢µ 3
0
0
0
0
0
1
3
3
4
27
ʾ». ÊÃÐá¡éÇ à¢µ 2
0
0
0
0
0
1
3
3
4
28
ʾ». ªÅºØÃÕ à¢µ 2
0
0
0
0
0
1
2
5
3
29
ʾ». ÊÁطûÃÒ¡Òà ࢵ 2
0
0
0
0
0
1
2
1
3
30
ʾ». ÊÁØ·Ãʧ¤ÃÒÁ
0
0
0
0
0
1
1
1
2
31
ʾ». ªÅºØÃÕ à¢µ 1
0
0
0
0
0
1
1
0
2
32
ʾ». »ÃÒ¨Õ¹ºØÃÕ à¢µ 1
0
0
0
0
0
1
0
4
1
33
ʾ». ÊÃкØÃÕ à¢µ 1
0
0
0
0
0
0
1
4
1
34
ʾ». ¹¹·ºØÃÕ à¢µ 2
0
0
0
0
0
0
1
3
1
35
ʾ». ÊÔ§ËìºØÃÕ
0
0
0
0
0
0
0
5
0
36
ʾ». ©ÐàªÔ§à·ÃÒ à¢µ 2
0
0
0
0
0
0
0
1
0
37
ʾ». »ÃÒ¨Õ¹ºØÃÕ à¢µ 2
0
0
0
0
0
0
0
0
0
38
ʾ». ¨Ñ¹·ºØÃÕ à¢µ 2
0
0
0
0
0
0
0
0
0
ÃÇÁ
8
8
8
24
31
42
51
84
124