SELECT stage,d, (case d when '03' then '25人及以下' when '04' then '26-30人' when '05' then '31-35人' when '06' then '36-40人' when '07' then '41-45人' when '08' then '46-50人' when '09' then '51-55人' when '10' then '56-60人' when '11' then '61-65人' when '12' then '66人及以上' end ), sum(sum) AS total FROM mv_dp_bane_stage_chengxiang GROUP BY d,stage order by (case when stage='小学' then 1 when stage='初中' then 2 when stage='高中' then 3 end),d