【MySQL】统计某一年中各个月的数据总和

需求

根据年份，统计12个月的每月行驶公里总和数

解决

select sum(case month(begin_time) when '1' then total_mileage else 0 end) as 1月,
sum(case month(begin_time) when '2' then total_mileage else 0 end) as 2月,
sum(case month(begin_time) when '3' then total_mileage else 0 end) as