Q&A for professionals, academics, and students working within the systems development life cycle
select count(*) N, datename(month, ClosedDate) month from Posts where ClosedDate is not null group by datename(month, ClosedDate) order by count(*) desc