Q&A about the site for ebook publishers and readers
-- Most prolific answering user for questions tagged 'r', by month SELECT TOP 10 C.UserId, Tn.TagName, COUNT(C.PostId) as PostCnt FROM Comments AS C INNER JOIN Posts AS P ON C.PostId = P.Id INNER JOIN PostTags AS T ON C.PostId = T.PostId INNER JOIN Tags AS Tn ON T.TagId = Tn.Id WHERE Tn.TagName IN ('r') GROUP BY C.UserId, Tn.TagName ORDER BY PostCnt DESC