查询各个成绩段的人数 case when 用法

SELECT
	count( 1 ) AS Num,
CASE
	WHEN price IS NULL THEN	'no_score' 
	WHEN price < '60' THEN	'不及格' 
	WHEN price BETWEEN '60' 	AND '80' THEN	'良好' 
	WHEN price BETWEEN '81' 	AND '90' THEN	'优秀'
	ELSE 'super' 
END AS description 
FROM
	mst_item 
GROUP BY
CASE
	WHEN price IS NULL THEN	'no_score' 
	WHEN price < '60' THEN	'不及格' 
	WHEN price BETWEEN '60' 	AND '80' THEN	'良好' 
	WHEN price BETWEEN '81' 	AND '90' THEN	'优秀'
	ELSE 'super' 
END