Q&A for researchers, developers, and users of Tor
SELECT COUNT(p.Id) AS 'Total Count of Posts tagged to Python', SUM(CASE WHEN YEAR(CreationDate) = YEAR(GETDATE()) THEN 1 END) AS 'Count for this Year' FROM Posts p JOIN PostTags pt ON pt.PostId = p.Id JOIN Tags t ON t.Id = pt.TagId WHERE t.TagName LIKE '%python%'