A list of the top 500 users with the highest average answer score excluding community wiki / closed posts or users with less than 10 answers
Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
SELECT TOP 500 Users.Id as [User Link], Count(Posts.Id) AS Answers, CAST(AVG(CAST(Score AS float)) as numeric(6,2)) AS [Average Answer Score] FROM Posts INNER JOIN Users ON Users.Id = OwnerUserId WHERE PostTypeId = 2 and CommunityOwnedDate is null and ClosedDate is null GROUP BY Users.Id, DisplayName HAVING Count(Posts.Id) > 10 ORDER BY [Average Answer Score] DESC