统计各个分值段的人数

记录sql

SELECT
    SUM(CASE WHEN practice_score < 59 then 1 ELSE 0 END) as level_1,
  SUM(CASE WHEN practice_score >= 60 and practice_score < 70 then 1 ELSE 0 END) as level_2,
  SUM(CASE WHEN practice_score >= 70 and practice_score < 80 then 1 ELSE 0 END) as level_3,
  SUM(CASE WHEN practice_score >= 80 and practice_score < 90 then 1 ELSE 0 END) as level_4,
  SUM(CASE WHEN practice_score >= 90 and practice_score <= 100 then 1 ELSE 0 END) as level_5
FROM
    practice_evalue_student
 WHERE 
practice_evaluate_id = 23

 

转载于:https://www.cnblogs.com/sunxun/p/10648914.html