Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT t.TagName, YEAR(p.CreationDate) AS Year, COUNT(*) AS QuestionsCount FROM Posts p JOIN PostTags pt ON p.Id = pt.PostId JOIN Tags t ON pt.TagId = t.Id WHERE p.PostTypeId = 1 -- Filter to include only questions and t.TagName = ##TagName## GROUP BY YEAR(p.CreationDate), t.TagName