·Õè
ࢵ¾×é¹·Õè¡ÒÃÈÖ¡ÉÒ
ª¹ÐàÅÔÈ
Ãͧ ñ
Ãͧ ò
ÃÇÁ
·Í§
à§Ô¹
·Í§á´§
à¢éÒÃèÇÁ
ÃÇÁ
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
ʾ». ¾Ãй¤ÃÈÃÕÍÂظÂÒ à¢µ 1
12
7
9
28
99
69
28
18
196
2
ʾ». ªÑ¹ҷ
11
6
4
21
102
52
35
18
189
3
ʾ». ÊÃÐá¡éÇ à¢µ 2
10
10
4
24
89
61
41
19
191
4
ʾ». žºØÃÕ à¢µ 2
10
4
4
18
93
70
35
22
198
5
ʾ». ÊÁØ·ÃÊÒ¤Ã
9
10
6
25
102
50
29
13
181
6
ʾ». ¨Ñ¹·ºØÃÕ à¢µ 1
9
8
6
23
97
61
25
15
183
7
ʾ». ¨Ñ¹·ºØÃÕ à¢µ 2
9
7
6
22
95
52
38
24
185
8
ʾ». ÊÁطûÃÒ¡Òà ࢵ 1
9
4
14
27
102
58
29
21
189
9
ʾ». ©ÐàªÔ§à·ÃÒ à¢µ 2
9
4
4
17
95
55
31
21
181
10
ʾ». ÊÃÐá¡éÇ à¢µ 1
9
3
6
18
100
56
29
20
185
11
ʾ». ÊÃкØÃÕ à¢µ 1
9
3
4
16
84
68
25
18
177
12
ʾ». µÃÒ´
8
11
3
22
95
53
22
21
170
13
ʾ». ªÅºØÃÕ à¢µ 1
8
8
14
30
105
58
38
12
201
14
ʾ». ªÅºØÃÕ à¢µ 3
8
6
12
26
109
49
33
13
191
15
ʾ». »·ØÁ¸Ò¹Õ ࢵ 1
8
6
5
19
87
58
32
20
177
16
ʾ». ÃÒªºØÃÕ à¢µ 2
7
9
7
23
104
61
34
19
199
17
ʾ». ÊÁطûÃÒ¡Òà ࢵ 2
6
10
4
20
93
46
25
27
164
18
ʾ». ¹¤Ã»°Á ࢵ 2
6
8
7
21
109
65
27
13
201
19
ʾ». ¡Ãا෾ÁËÒ¹¤Ã
6
6
4
16
69
46
26
13
141
20
ʾ». ÊؾÃóºØÃÕ à¢µ 3
6
4
6
16
82
64
30
15
176
21
ʾ». ÃÒªºØÃÕ à¢µ 1
5
10
9
24
100
69
25
16
194
22
ʾ». ©ÐàªÔ§à·ÃÒ à¢µ 1
5
4
13
22
100
60
33
17
193
23
ʾ». ÊÔ§ËìºØÃÕ
5
3
2
10
67
58
39
20
164
24
ʾ». ÊؾÃóºØÃÕ à¢µ 2
5
2
6
13
73
47
31
18
151
25
ʾ». ¹¤Ã»°Á ࢵ 1
5
2
4
11
72
80
42
9
194
26
ʾ». žºØÃÕ à¢µ 1
4
7
7
18
92
56
34
19
182
27
ʾ». ÃÐÂͧ ࢵ 1
4
6
8
18
93
63
27
15
183
28
ʾ». ÃÐÂͧ ࢵ 2
4
6
3
13
64
62
22
21
148
29
ʾ». ÍèÒ§·Í§
4
3
4
11
83
70
34
15
187
30
ʾ». »·ØÁ¸Ò¹Õ ࢵ 2
4
3
4
11
78
58
29
25
165
31
ʾ». ¡Ò¨¹ºØÃÕ à¢µ 3
4
1
4
9
75
56
33
23
164
32
ʾ». ¹¤Ã¹Ò¡
3
4
2
9
65
61
42
15
168
33
ʾ». ྪúØÃÕ à¢µ 1
3
3
5
11
64
54
32
16
150
34
ʾ». »ÃШǺ¤ÕÃբѹ¸ì ࢵ 2
3
2
2
7
59
51
40
16
150
35
ʾ». ¾Ãй¤ÃÈÃÕÍÂظÂÒ à¢µ 2
3
1
3
7
62
64
36
30
162
36
ʾ». ªÅºØÃÕ à¢µ 2
2
10
5
17
82
61
29
23
172
37
ʾ». ¹¹·ºØÃÕ à¢µ 1
2
10
3
15
86
50
28
20
164
38
ʾ». ¹¹·ºØÃÕ à¢µ 2
2
7
2
11
81
53
46
28
180
39
ʾ». ÊؾÃóºØÃÕ à¢µ 1
2
6
4
12
65
67
33
19
165
40
ʾ». ¡Ò¨¹ºØÃÕ à¢µ 1
2
6
3
11
69
61
39
24
169
41
ʾ». ÊÃкØÃÕ à¢µ 2
2
3
6
11
72
73
27
19
172
42
ʾ». ¡Ò¨¹ºØÃÕ à¢µ 2
2
3
1
6
46
46
37
22
129
43
ʾ». ¡Ò¨¹ºØÃÕ à¢µ 4
2
0
3
5
66
72
36
20
174
44
ʾ». »ÃÒ¨Õ¹ºØÃÕ à¢µ 1
1
3
2
6
58
37
41
14
136
45
ʾ». ྪúØÃÕ à¢µ 2
1
2
1
4
56
53
31
20
140
46
ʾ». »ÃШǺ¤ÕÃբѹ¸ì ࢵ 1
0
4
2
6
71
52
34
18
157
47
ʾ». ÊÁØ·Ãʧ¤ÃÒÁ
0
3
3
6
61
44
32
18
137
48
ʾ». »ÃÒ¨Õ¹ºØÃÕ à¢µ 2
0
3
2
5
54
59
38
23
151
ÃÇÁ
248
251
242
741
3,925
2,789
1,562
905
8,276