ÊÃØ»Íѹ´Ñº áÅÐàËÃÕÂÃÒ§ÇÑŠʾ». áÁèÎèͧÊ͹ ࢵ 2
·Õè
âçàÃÕ¹
ª¹ÐàÅÔÈ
Ãͧ ñ
Ãͧ ò
ÃÇÁ
·Í§
à§Ô¹
·Í§á´§
à¢éÒÃèÇÁ
ÃÇÁ
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=44 AND im_school.area_type_id=1 AND im_school.zone_num=2 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
·Í§ÊÇÑÊ´ÔìÇÔ·ÂÒ¤ÒÃ
12
7
3
22
22
4
1
1
27
2
ºéÒ¹ËéÇÂÊÔ§Ëì
9
10
4
23
22
8
4
0
34
3
ªØÁª¹ºéÒ¹¹éÓ´Ôº
9
5
2
16
16
2
1
1
19
4
͹غÒŸÒ÷ԾÂì
9
5
1
15
17
1
0
0
18
5
ºéҹ⾫Í
8
6
4
18
27
14
10
6
51
6
ÃÒª»ÃЪҹØà¤ÃÒÐËì 21
8
6
3
17
13
9
4
1
26
7
ä·ÂÃÑ°ÇÔ·ÂÒ 33 (ºéÒ¹·Ø觾ÃéÒÇ)
8
5
5
18
13
6
3
1
22
8
ºéÒ¹äÃèÇÔ·ÂÒ
7
3
1
11
14
1
1
1
16
9
ºéÒ¹¨ÍÁá¨é§ÁÔµÃÀÒ¾·Õè 193
6
6
3
15
19
4
2
0
25
10
ªØÁª¹áÁèÅÒÈÖ¡ÉÒ
6
4
2
12
16
8
5
3
29
11
ºéÒ¹ÍÁ¾ÒÂ
6
2
2
10
13
11
3
0
27
12
ªØÁª¹ºéÒ¹¼Ò¼èÒ
6
1
3
10
14
5
3
3
22
13
ÃèÁ©ÑµÃÇÔ·ÂÒ (à·ÈºÒÅ ò)
5
4
3
12
12
4
5
0
21
14
ºéÒ¹á¾Ð¾Ô·ÂÒ
4
7
2
13
11
11
1
1
23
15
ÊѧÇÒÅÂìÇÔ·ÂÒ
4
5
4
13
16
9
1
2
26
16
ºéÒ¹áÁèÊÇ´
4
3
3
10
18
21
9
9
48
17
ºéÒ¹ËéÇ·ÃÒÂ
4
2
1
7
6
4
0
1
10
18
͹غÒÅáÁèÅÒ¹éÍÂ
4
1
0
5
8
3
2
1
13
19
ºéÒ¹«ÔÇÒà´Í
4
0
2
6
12
7
2
3
21
20
ºéÒ¹ËéÇ¡Øé§
3
3
2
8
11
6
4
2
21
21
ºéÒ¹ËéǼÖé§ãËÁè
3
3
1
7
14
3
5
4
22
22
´Í¹ªÑÂÇÔ·ÂÒ
3
2
2
7
16
11
1
2
28
23
ºéÒ¹áÁèà§Ò
3
1
2
6
6
4
1
0
11
24
ºéÒ¹ËéÇÂâ¼
3
1
1
5
7
2
0
2
9
25
ºéÒ¹ËéÇÂáËé§
3
1
1
5
6
0
0
1
6
26
ºéҹʺàÁÂ
3
1
0
4
6
0
0
1
6
27
ä·è¨§
3
1
0
4
5
6
2
2
13
28
͹غÒÅʺàÁÂ(¤Í¹¼Öé§)
2
6
5
13
16
7
3
1
26
29
ºéÒ¹ËéÇÂÎÒ¡äÁéãµé
2
3
2
7
9
4
3
4
16
30
ºéÒ¹àÅâ¤Ð
2
2
7
11
10
9
3
0
22
31
ºéÒ¹áÁè¢Õ´
2
2
3
7
8
8
2
0
18
32
ºéÒ¹ÅÐÍÙº
2
2
1
5
6
6
6
5
18
33
ºéÒ¹áÁèàµÕëÂ
2
1
2
5
9
10
3
1
22
34
ºéÒ¹ËéÇÂÇÍ¡
2
1
2
5
8
2
1
2
11
35
ºéÒ¹¤Ð»Ç§
2
1
0
3
4
2
1
0
7
36
ºéÒ¹·ÔÂÒà¾Í
2
0
1
3
3
4
0
0
7
37
ºéÒ¹áÁè¨êÒ§ ÊÒ¢Ò ´§¹éÍÂ-´§ËÅǧ
2
0
0
2
4
3
2
3
9
38
ºéÒ¹áÁè¡Í§¤Ò
2
0
0
2
2
0
0
0
2
39
ºéÒ¹»èÒËÁÒ¡
1
4
0
5
4
1
0
0
5
40
ºéÒ¹·èÒÊͧá¤Ç
1
3
3
7
9
9
2
1
20
41
ºéÒ¹¹Ò´ÍÂ
1
3
2
6
11
4
1
0
16
42
ºéÒ¹áÁè¡Í§á»
1
3
2
6
6
1
1
1
8
43
ºéÒ¹·èÒµÒ½Ñè§
1
3
0
4
7
3
2
1
12
44
ºéÒ¹áÁèÅÔ´
1
2
2
5
7
7
5
1
19
45
͹غÒÅáÁèÊÐàÃÕ§ (ºéÒ¹â»è§)
1
2
0
3
5
1
2
0
8
46
ºéÒ¹¡Í§¡ëÍÂ
1
1
4
6
7
14
7
2
28
47
ºéÒ¹ºØàÅÍ
1
1
3
5
7
1
1
1
9
48
ºéÒ¹áÁèáź
1
1
2
4
4
2
0
3
6
49
ºéÒ¹áÁèÅÒÁÒ
1
1
1
3
4
1
2
3
7
50
ºéÒ¹ËéǼÖé§
1
0
1
2
6
5
8
4
19
51
à¨éÒ¾èÍËÅǧÍØ»¶ÑÁÀì 10
1
0
1
2
4
6
1
0
11
52
ºéÒ¹áÁè»Ò§
1
0
1
2
2
7
2
2
11
53
ºéÒ¹áÁèµéͺãµé
1
0
0
1
3
1
0
0
4
54
à¾Õ§ËÅǧ 11
1
0
0
1
2
1
0
0
3
55
ºéÒ¹ËÑÇÅÒ
1
0
0
1
1
2
0
0
3
56
ºéÒ¹ËéÇÂÁèǧ
1
0
0
1
1
1
2
0
4
57
ºéÒ¹áÁèÍØÁ¾ÒÂ
1
0
0
1
1
0
0
2
1
58
ºéÒ¹¼ÒàÂÍ
1
0
0
1
1
0
0
1
1
59
ºéÒ¹¿Ñ¡·Í§
1
0
0
1
1
0
0
0
1
60
ºéÒ¹ËéÇÂÁС͡
1
0
0
1
1
0
0
0
1
61
ºéÒ¹áÁèâ¶
0
2
4
6
8
6
4
3
18
62
ºéÒ¹ËéÇÂËéÒ
0
2
3
5
6
3
2
0
11
63
ºéÒ¹áÁèÊÒÁáź
0
2
2
4
4
4
2
0
10
64
ºéÒ¹¡Í§á»ãµé
0
2
0
2
3
4
2
0
9
65
ºéÒ¹ËéÇÂà´×èÍ
0
1
2
3
5
2
0
0
7
66
ºéÒ¹ÊѹµÔÊØ¢
0
1
1
2
3
2
0
2
5
67
ºéÒ¹áÁèµéͺà˹×Í
0
1
1
2
2
2
0
1
4
68
ºéÒ¹·èÒ¼Ò»ØéÁ
0
1
1
2
1
8
3
0
12
69
ºéÒ¹áÁèÍÍ¡à˹×Í
0
1
1
2
1
4
0
2
5
70
ºéÒ¹¡Í¡ËÅǧ
0
1
0
1
4
4
3
2
11
71
ºéÒ¹áÁè¡ë͹
0
1
0
1
3
0
1
0
4
72
Åèͧá¾ÇÔ·ÂÒ
0
1
0
1
2
4
1
0
7
73
ºéÒ¹áÁèÊÇÃäì¹éÍÂ
0
1
0
1
2
2
2
2
6
74
ºéÒ¹áÁè¹Ò¨Ò§à˹×Í
0
1
0
1
2
0
1
1
3
75
ºéÒ¹áÁè¨êÒ§
0
1
0
1
1
3
1
5
5
76
ºéÒ¹ËÑÇáÁèâ¶
0
1
0
1
1
1
0
0
2
77
ºéÒ¹·Øè§á¾Á
0
1
0
1
1
0
1
0
2
78
͹غÒÅà·ÈºÒŵӺÅáÁèÂÇÁ
0
1
0
1
1
0
1
0
2
79
ºéÒ¹»èÒËÁÒ¡ÇÔ·ÂÒ
0
1
0
1
1
0
0
0
1
80
ÅØèÁ¹éÓÇÔ·ÂÒ
0
1
0
1
1
0
0
0
1
81
͹غÒÅ¡Äɳ¾Ãó
0
1
0
1
1
0
0
0
1
82
͹غÒÅà·ÈºÒÅáÁèÅÒ¹éÍÂ
0
1
0
1
1
0
0
0
1
83
ÈÔÉÂìà¡èÒ¾ÂÒºÒÅÈÔÃÔÃÒªºéÒ¹´§
0
0
4
4
4
7
3
3
14
84
ºéÒ¹ÊÒÁ
0
0
2
2
6
5
0
0
11
85
ºéÒ¹áÁèËÒÃ
0
0
2
2
5
0
0
0
5
86
ºéÒ¹áÁèÊÇÃäìËÅǧ
0
0
2
2
2
5
2
1
9
87
ºéÒ¹áÁèÍÍ¡
0
0
2
2
1
1
0
0
2
88
ºéÒ¹áÁèá¾
0
0
1
1
3
0
1
0
4
89
ºéÒ¹ÊéÁ»èÍÂ
0
0
1
1
2
8
3
0
13
90
ºéÒ¹áÁèÅÐ
0
0
1
1
2
2
0
1
4
91
ºéÒ¹áÁèáÅÐ
0
0
1
1
2
0
1
0
3
92
ºéÒ¹áÁèá¾ËÅǧ
0
0
1
1
2
0
0
1
2
93
ºéÒ¹¨Í«Ôà´Íà˹×Í
0
0
1
1
2
0
0
0
2
94
ºéÒ¹ËéÇÂËÁÙ¾Ô·ÂÒ
0
0
1
1
2
0
0
0
2
95
ºéÒ¹ËéÇ¡ͧÁÙÅ
0
0
1
1
1
3
1
1
5
96
ºéÒ¹áÁè·ÐÅØ
0
0
1
1
1
1
1
0
3
97
ºéÒ¹´Í§ÒÁ
0
0
1
1
1
1
0
0
2
98
ºéÒ¹ËéÇ¡ͧ¡éÒ´
0
0
1
1
0
2
4
3
6
99
ºéҹʺËÒÃ
0
0
1
1
0
0
0
1
0
100
ºéÒ¹¼Òá´§ËÅǧ
0
0
0
0
4
1
0
2
5
101
ºéÒ¹¢Ø¹áÁèÅÒ
0
0
0
0
3
4
4
2
11
102
ºéÒ¹ËéÇ»ÅÒ¡Ñé§
0
0
0
0
3
2
2
2
7
103
ºéÒ¹áÁèËÅØÂ
0
0
0
0
3
2
1
0
6
104
ºéÒ¹áÁè¹Ò¨Ò§
0
0
0
0
3
1
1
0
5
105
ºéÒ¹ËéÇÂä¡è»èÒÇÔ·ÂÒ
0
0
0
0
2
4
0
1
6
106
ºéÒ¹ÍØÁ´Òà˹×Í
0
0
0
0
2
2
2
0
6
107
ºéÒ¹ËéÇ¡Ùè»êÐ
0
0
0
0
2
1
1
1
4
108
ºéÒ¹´§ãËÁè
0
0
0
0
2
0
1
0
3
109
ºéÒ¹ËéǹéÓãÊ
0
0
0
0
2
0
0
1
2
110
ºéÒ¹áÁèÎØ
0
0
0
0
2
0
0
0
2
111
ºéÒ¹áÁèÊÐáÁ§
0
0
0
0
1
3
2
1
6
112
ºéÒ¹µé¹§ÔéÇ
0
0
0
0
1
3
0
0
4
113
ºéÒ¹áÁèà¡ÒÐ
0
0
0
0
1
3
0
0
4
114
ºéÒ¹áÁèÅÒÂ
0
0
0
0
1
2
3
3
6
115
ºéÒ¹»èÒ⻧
0
0
0
0
1
2
0
0
3
116
ºéҹ˹ͧÁèǹ
0
0
0
0
1
1
4
0
6
117
ºéÒ¹ÍØÁ´Òãµé
0
0
0
0
1
1
1
0
3
118
Ãѵ¹»ÃзջÇÔ·ÂÒ
0
0
0
0
1
1
1
0
3
119
ºéÒ¹¾ÐÁÍÅÍ
0
0
0
0
1
1
0
0
2
120
ºéÒ¹ÍØÁâÅêÐà˹×Í
0
0
0
0
1
1
0
0
2
121
ºéÒ¹áÁè¨Í
0
0
0
0
1
1
0
0
2
122
ºéÒ¹áÁèÊСÑêÇÐ
0
0
0
0
1
1
0
0
2
123
͹غÒźéÒ¹¡ÒÈ
0
0
0
0
1
1
0
0
2
124
ºéÒ¹¡ÅÍà«âÅ
0
0
0
0
1
0
1
0
2
125
ºéÒ¹ªèÒ§ËÁéÍ
0
0
0
0
1
0
1
0
2
126
ºéÒ¹·Ðâŧà˹×Í
0
0
0
0
1
0
1
0
2
127
ºéÒ¹à¤ÃÍкÍ
0
0
0
0
1
0
1
0
2
128
ºéÒ¹´ÙÅÒà»ÍÃ
0
0
0
0
1
0
0
3
1
129
ÈÙ¹Âì¡ÒÃàÃÕ¹ÃÙé µª´. ºéÒ¹¨Í»ÃÒ¤Õ
0
0
0
0
1
0
0
0
1
130
ºéÒ¹ËéÇ¡ÃеèÒÂ
0
0
0
0
1
0
0
0
1
131
ºéÒ¹áÁèÅÒ¼ÒäËÇ
0
0
0
0
1
0
0
0
1
132
ºéÒ¹ËéÇÂäÁé«Ò§
0
0
0
0
0
7
0
0
7
133
ºéÒ¹·ÕÎ×ÍÅ×Í
0
0
0
0
0
5
1
1
6
134
ºéÒ¹áÁè¡Ðä¹
0
0
0
0
0
3
4
0
7
135
ºéÒ¹»èÒá¡è
0
0
0
0
0
3
2
0
5
136
ºéÒ¹áÁèÊÐÅÒº
0
0
0
0
0
3
1
1
4
137
ºéÒ¹´ÍÂàÅÕèÂÁ
0
0
0
0
0
2
1
0
3
138
ºéÒ¹áÁèÊØ
0
0
0
0
0
1
1
0
2
139
»èÒ⻧ÊÒ¢ÒºéÒ¹¡Í§á»à˹×Í
0
0
0
0
0
1
1
0
2
140
ºéÒ¹ËéÇÂä¡è»èÒ
0
0
0
0
0
1
1
0
2
141
ºéÒ¹áÁèÊлÖë§ãµé
0
0
0
0
0
1
1
0
2
142
ºéÒ¹áÁèÍØÁ»êÍ¡
0
0
0
0
0
1
0
1
1
143
ºéÒ¹¢Ø¹áÁèµéͺ
0
0
0
0
0
1
0
0
1
144
ºéÒ¹ËéÇÂËÁҡ˹ع
0
0
0
0
0
1
0
0
1
145
ÈÙ¹Âì¡ÒÃàÃÕ¹ÃÙé µª´. ºéÒ¹»ÍËÁ×éÍ
0
0
0
0
0
1
0
0
1
146
ºéÒ¹¡ÍÁÙà´Í
0
0
0
0
0
1
0
0
1
147
ºéÒ¹µé¹§ÔèÇÊÒ¢ÒºéÒ¹ËéÇÂàËÕêÂÐ
0
0
0
0
0
1
0
0
1
148
ºéÒ¹áÁè¡ÇÒ§ãµé
0
0
0
0
0
1
0
0
1
149
ºéÒ¹áÁèµÍÅÐ
0
0
0
0
0
1
0
0
1
150
ºéÒ¹áÁè»Øë¹
0
0
0
0
0
1
0
0
1
151
ºéÒ¹áÁèÍØÁÅͧ
0
0
0
0
0
1
0
0
1
152
ºéÒ¹¢Ø¹Ç§à˹×Í
0
0
0
0
0
0
2
0
2
153
ºéÒ¹áÁè¤ÐµÇ¹
0
0
0
0
0
0
1
0
1
154
ºéÒ¹áÁèà¡ÒÐÇÔ·ÂÒ
0
0
0
0
0
0
1
0
1
155
ºéÒ¹áÁèá¾¹éÍÂ
0
0
0
0
0
0
0
2
0
156
ºéÒ¹¢Ø¹Ç§
0
0
0
0
0
0
0
2
0
157
ºéÒ¹ËéÇ¡ͧà»êÒÐ
0
0
0
0
0
0
0
0
0
158
ÈÙ¹Âì¡ÒÃàÃÕ¹ÃÙé µª´. ºéÒ¹â¡á»ÃÐ
0
0
0
0
0
0
0
0
0
159
µª´.áÁèÅÒ§ÔéÇ
0
0
0
0
0
0
0
0
0
160
ºéÒ¹ËéÇ¡ͧÁÙÅ ÊҢҢعáÁè¤ÐµÇ¹
0
0
0
0
0
0
0
0
0
161
ºéÒ¹áÁèËÒ´
0
0
0
0
0
0
0
0
0
ÃÇÁ
191
163
141
495
672
445
214
138
1,331