按月统计数据

select count(ArticleID), datename(year, AddTime) as year, datename(month, AddTime) as month
from Blog_Article where UserID=163 and Status=2
group by datename(year, AddTime) , datename(month, AddTime)