select ç级,
sum(case when åæ°>=A and åæ°<B then 1 else 0 end) A,
sum(case when åæ°>=B and åæ°<C then 1 else 0 end) B,
sum(case when åæ°>=C and åæ°<D then 1 else 0 end) C,
sum(case when åæ°>=D then 1 else 0 end) D
from 表å
group by ç级
追é®æ表ï¼åScores
æStudentIdï¼ClassIdï¼Scoreä¸ä¸ªå段
å¦ä½ç¨sqlè¯å¥å°åçå¹³ååç®åºï¼å¹¶æå¹³ååå¾åºåçå次ï¼
æå®å¨æ¯æ³ä¸åºæ¥äºï¼æ±åä½å¸®å¿
追çä½ éæ°é®ï¼ä½ æåæ³æ¥åºåªå åï¼
è¿ä¸ªå
é纳äº