报表统计 一年每月数据sql

select year(create_date) 年,
month(create_date) 月,
sum(1) 合计
from casic_xq_js
where create_date BETWEEN '2017-1-1' and '2017-12-31'
group by year(create_date),
month(create_date)