Q&A for professional mathematicians
select month(CreationDate), count(Id) from Posts where year(CreationDate) = ##Year## and ClosedDate IS NOT NULL group by month(CreationDate) order by month(CreationDate) asc