Users with most answers

3

Please login or register to vote for this query.

(click on this box to dismiss)

Just a lsit of suers which wrote the most answers

Ask Ubuntu

Q&A for Ubuntu users and developers

-- Users with most answers
-- Just a list of users who wrote the most answers

SELECT TOP ##NumberOfUsers## s.userId as [User Link], u.DisplayName, s.answerCount, u.Reputation, u.Reputation / s.answerCount as peransweravg
FROM (
SELECT u.Id AS userId, COUNT(p.Id) AS answerCount
FROM Users AS u JOIN Posts AS p ON u.Id=p.OwnerUserId
WHERE p.PostTypeId = 2
GROUP BY u.Id
) AS s
JOIN Users AS u ON s.userId=u.Id
ORDER BY s.answerCount DESC

Enter Parameters

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