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 Joomla! administrators, users, developers and designers
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) > 1000 ORDER BY [Average Answer Score] DESC