mysql 处理 某年 的 12个月份 数据 统计

select
yearList.c_month month,
IFNULL(allss.num_value, 0 )/12 num_value
from (
select concat(#{year},'-01')AS "c_month"
union select concat(#{year},'-02')AS "c_month"
union select concat(#{year},'-03')AS "c_month"
union select concat(#{year},'-04')AS "c_month"
union select concat(#{year},'-05')AS "c_month"
union select concat(#{year},'-06')AS "c_month"
union select concat(#{year},'-07')AS "c_month"
union select concat(#{year},'-08')AS "c_month"
union select concat(#{year},'-09')AS "c_month"
union select concat(#{year},'-10')AS "c_month"
union select concat(#{year},'-11')AS "c_month"
union select concat(#{year},'-12')AS "c_month"
)yearList
LEFT JOIN ( 业务表 )allss

GROUP BY
date_format(appraises_time,'%Y-%m')
ORDER BY
date_format(appraises_time,'%Y-%m')
)allss ON yearList.c_month = allss.appraises_time