Q&A for science fiction and fantasy enthusiasts
SELECT COUNT(*) as TotalQuestions, YEAR(CreationDate) as Year FROM Posts WHERE Tags LIKE '%<swift>%' AND PostTypeId = 1 AND YEAR(CreationDate) = 2023 -- change this year to the one you're interested in GROUP BY YEAR(CreationDate)