1、时间字段是datetime类型
2、需要用到中间表,表结构和数据链接下载
链接:https://pan.baidu.com/s/1tAFU4nm1p4CkSneXwceA_A
提取码:b3xi
3、前两个 adddate 月日需要在代码中写死 从每年的-01-01开始,-最后一个日期同理xxxx-12-31
4、下面是sql
select concat(month(years.date),'月') as year, years.date, date_format(years.date, '%Y-%m') AS years, sum( case when bri.status = '1' then 1 else 0 end ) as num, -- 总数 sum( case when bri.status = '1' and bri.sex='1' then 1 else 0 end ) as numman, -- 男性数量 sum( case when bri.status = '1' and bri.sex='