关注主题
CASE WHEN score >= 90 THEN '90-100' WHEN score >= 80 THEN '80-89' WHEN score >= 70 THEN '70-79' WHEN score >= 60 THEN '60-69' ELSE '0-59' END AS score_range, COUNT(*) AS student_count FROM students GROUP BY score_range;
赞 举报
本版积分规则 发表回复 回帖后跳转到最后一页