Sql语句(MySql)

范围统计查询

SELECT
	ageproportion AS '工资范围',
	count(*) AS '人数' 
FROM
	(
	SELECT
	CASE
			
		WHEN
			money < 6000 AND money > 4000 THEN
				'4000~6000之间' 
				WHEN money < 8000 AND money > 6000 THEN
				'6000~8000之间' ELSE '8000以上' 
			END AS ageproportion 
		FROM
			t_user 
		) a 
GROUP BY
	ageproportion