Q&A for people using the vi and Vim families of text editors
SELECT COUNT(Id), datepart(yyyy, CreationDate) FROM Posts GROUP BY datepart(yyyy, CreationDate);