Q&A for people looking to improve their interpersonal communication skills
Select datepart(yyyy, ClosedDate),COUNT(Id) from Posts where ClosedDate BETWEEN '2008/01/01' AND '2018/12/31' AND PostTypeId = 1 group by datepart(yyyy, ClosedDate) Order by datepart(yyyy, ClosedDate) asc