Top Users by Average Answer Vote

0

Please login or register to vote for this query.

(click on this box to dismiss)

Selects the top 100 users as ordered by the average score of all their answers. Restricted to users with at least 8 answers to avoid statistical fluctuations. (8 was a semi-arbitrary choice; this would have to be adjusted by site)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Top Users by Average Answer Vote
-- Selects the top 100 users as ordered by the average score of all their
-- answers. Restricted to users with at least 8 answers to avoid statistical
-- fluctuations. (8 was a semi-arbitrary choice; this would have to be
-- adjusted per site)

SELECT TOP 100000
    Users.Id as [User Link],
    Users.Reputation,
    Count(Posts.Id) AS Answers,
    max(Users.Reputation)/Count(Posts.Id) AS AverageAnswerScore
FROM Posts
    INNER JOIN Users ON Users.Id = OwnerUserId
WHERE PostTypeId = 2
GROUP BY Users.Id, DisplayName, Users.Reputation
HAVING Count(Posts.Id) > 1300
ORDER BY AverageAnswerScore DESC

Enter Parameters

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