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 for people looking to bypass life's everyday problems with simple tricks
SELECT TOP 100 Users.Id as [User Link], Count(Posts.Id) AS Answers, Users.Reputation, 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 and Users.location not in ('UK','China','India') GROUP BY Users.Id, DisplayName, Users.Reputation HAVING Count(Posts.Id) > 10 ORDER BY [Average Answer Score] DESC