Sql语句查询每一年每个月的数量信息

select year(CreatTime) 年,
month(CreatTime) 月,
COUNT(1) as 数量
from iwebsoft_news
where year(CreatTime)='2020' and isRecyle=0
group by year(CreatTime),
month(CreatTime)
order by month(CreatTime)