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