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

Q&A for professional and enthusiast programmers

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

fork query

edited sep 18 14 jon.doe14699

created jun 30 10 anonymous