摘要： select score as 类别,count(*) as 人数 from (select case when fen>=60 then '及格' else '不及格' end as score from fen ) fen group by score 阅读全文