Q&A for professional and enthusiast programmers
select count(*) FROM Tags JOIN PostTags ON Tags.Id = PostTags.TagId JOIN Posts ON Posts.Id = PostTags.PostId JOIN Comments ON Posts.Id = Comments.PostId WHERE Tags.TagName IN ('scala') AND Posts.CreationDate > DATEADD(Month, -24, DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0) );