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)

Physics

Q&A for active researchers, academics and students of physics

-- 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 to meta site
loading Hold tight while we fetch your results