Q&A for people looking to bypass life's everyday problems with simple tricks
SELECT COUNT(pt.PostId), YEAR(p.CreationDate) FROM Posts as p LEFT JOIN PostTags as pt ON p.Id = pt.PostId LEFT JOIN Tags AS t ON pt.TagId = t.Id GROUP BY p.CreationDate