范围统计查询 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