81,092
社区成员
发帖
与我相关
我的任务
分享
select belong,[name],sum(case when DATE_FORMAT(report,'%m')=1 then 1 else 0 end) as cnt1,
sum(case when DATE_FORMAT(report,'%m')=2 then 1 else 0 end) as cnt2,
sum(case when DATE_FORMAT(report,'%m')=3 then 1 else 0 end) as cnt3,
sum(case when DATE_FORMAT(report,'%m')=4 then 1 else 0 end) as cnt4,
sum(case when DATE_FORMAT(report,'%m')=5 then 1 else 0 end) as cnt5,
sum(case when DATE_FORMAT(report,'%m')=6 then 1 else 0 end) as cnt6
from tt group by belong,[name],cnt1