Most Prolific answering users for r tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Travel Answers

Q&A for road warriors and seasoned travelers

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results