使用case whencase when xx between '2012/12/21' and '2013/1/20' then ’1月‘ ...when xx between '2013/11/21' and '2013/12/20' then ’12月‘ end as 月份作为子查询,外面group by 一下