0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software developers, mathematicians and others interested in cryptography

-- 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

fork query

edited oct 19 17

created oct 19 17 anonymous