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)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

-- 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 100
    Users.Id as [User Link],
    Count(Posts.Id) AS Answers,
    AVG(CAST(Score AS float)) AS AverageAnswerScore
FROM Posts
    INNER JOIN Users ON Users.Id = OwnerUserId
WHERE PostTypeId = 2 AND Reputation > 1000
GROUP BY Users.Id, DisplayName
HAVING Count(Posts.Id) > 8
ORDER BY AverageAnswerScore DESC

Enter Parameters

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