获取近一年（12个月）的记录数统计（按月份）

近一年（12个月）项目数量统计，按月份，同时将月份格式化

select to_char(create_time, 'YYYY-MM') as createDate,count(id) as count 
from project_info group by createDate order by createDate desc limit 12