·Õè
ࢵ¾×é¹·Õè¡ÒÃÈÖ¡ÉÒ
ª¹ÐàÅÔÈ
Ãͧ ñ
Ãͧ ò
ÃÇÁ
·Í§
à§Ô¹
·Í§á´§
à¢éÒÃèÇÁ
ÃÇÁ
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
16
11
13
40
133
60
23
12
216
2
ʾ». àªÕ§ãËÁè ࢵ 3
14
13
8
35
118
57
17
13
192
3
ʾ». àªÕ§ÃÒ ࢵ 3
12
11
11
34
114
50
21
14
185
4
ʾ». àªÕ§ãËÁè ࢵ 2
10
5
4
19
110
62
33
11
205
5
ʾ». ¾ÔɳØâÅ¡ ࢵ 1
10
3
9
22
91
68
29
14
188
6
ʾ». ¾ÔɳØâÅ¡ ࢵ 2
9
9
7
25
121
69
17
14
207
7
ʾ». ÍØ·ÑÂ¸Ò¹Õ à¢µ 2
9
7
3
19
109
58
19
12
186
8
ʾ». ¹¤ÃÊÇÃäì ࢵ 3
9
7
1
17
115
52
28
12
195
9
ʾ». ¾ÔɳØâÅ¡ ࢵ 3
9
6
6
21
104
74
27
13
205
10
ʾ». á¾Ãè ࢵ 1
9
6
6
21
93
60
20
11
173
11
ʾ». àªÕ§ÃÒ ࢵ 4
8
9
12
29
97
70
17
14
184
12
ʾ». ¾Ô¨ÔµÃ ࢵ 2
8
2
5
15
93
54
24
13
171
13
ʾ». àªÕ§ÃÒ ࢵ 2
7
10
9
26
103
67
16
10
186
14
ʾ». ÊØ⢷Ñ ࢵ 2
7
9
12
28
97
67
26
18
190
15
ʾ». ¡Óᾧྪà ࢵ 1
7
6
5
18
96
69
22
14
187
16
ʾ». ¡Óᾧྪà ࢵ 2
7
6
3
16
106
56
26
18
188
17
ʾ». ¾ÐàÂÒ à¢µ 2
6
11
8
25
112
53
15
15
180
18
ʾ». ¹èÒ¹ ࢵ 1
6
10
8
24
109
57
21
12
187
19
ʾ». µÒ¡ ࢵ 2
6
9
9
24
118
59
18
11
195
20
ʾ». ÅÓ»Ò§ ࢵ 1
6
4
3
13
83
70
32
13
185
21
ʾ». àªÕ§ÃÒ ࢵ 1
5
9
5
19
98
42
23
11
163
22
ʾ». ྪúÙóì ࢵ 3
5
5
6
16
114
60
23
14
197
23
ʾ». ÍصôԵ¶ì ࢵ 1
5
4
6
15
98
67
27
11
192
24
ʾ». ÊØ⢷Ñ ࢵ 1
4
9
3
16
98
61
18
11
177
25
ʾ». ¹¤ÃÊÇÃäì ࢵ 2
4
7
7
18
92
70
27
15
189
26
ʾ». ྪúÙóì ࢵ 2
4
7
1
12
89
66
22
15
177
27
ʾ». àªÕ§ãËÁè ࢵ 1
4
6
8
18
99
77
25
10
201
28
ʾ». ÍØ·ÑÂ¸Ò¹Õ à¢µ 1
4
6
1
11
71
44
32
16
147
29
ʾ». á¾Ãè ࢵ 2
4
5
5
14
96
56
18
10
170
30
ʾ». ¹¤ÃÊÇÃäì ࢵ 1
4
2
3
9
90
60
30
14
180
31
ʾ». ÅÓ¾Ù¹ ࢵ 2
3
5
5
13
86
59
32
15
177
32
ʾ». ¾Ô¨ÔµÃ ࢵ 1
3
5
5
13
79
75
31
18
185
33
ʾ». àªÕ§ãËÁè ࢵ 4
3
5
2
10
92
57
25
14
174
34
ʾ». ÅÓ»Ò§ ࢵ 2
3
4
8
15
99
55
22
13
176
35
ʾ». ¾ÐàÂÒ à¢µ 1
3
3
5
11
89
63
30
12
182
36
ʾ». ྪúÙóì ࢵ 1
3
2
7
12
104
57
33
16
194
37
ʾ». áÁèÎèͧÊ͹ ࢵ 2
3
2
2
7
71
65
27
16
163
38
ʾ». áÁèÎèͧÊ͹ ࢵ 1
3
2
1
6
67
51
27
21
145
39
ʾ». ÍصôԵ¶ì ࢵ 2
3
0
2
5
62
57
38
18
157
40
ʾ». µÒ¡ ࢵ 1
2
6
2
10
104
67
27
16
198
41
ʾ». àªÕ§ãËÁè ࢵ 5
1
5
2
8
74
65
24
21
163
42
ʾ». ÅÓ»Ò§ ࢵ 3
1
1
3
5
66
51
33
17
150
43
ʾ». àªÕ§ãËÁè ࢵ 6
1
0
1
2
68
64
28
19
160
44
ʾ». ÅÓ¾Ù¹ ࢵ 1
0
4
6
10
74
67
27
13
168
ÃÇÁ
250
258
238
746
4,202
2,688
1,100
620
7,990