instruction: Top answerers on the site. A list of the top users with the highest average answer score excluding
  community wiki / closed posts or users with fewer than 10 answers
response: WITH UserAvgAnswerScore AS (SELECT Users.Id AS UserId, COUNT(Posts.Id) AS Answers, CAST(AVG(CAST(Score AS FLOAT)) AS FLOAT(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) > 100) SELECT RANK() OVER (ORDER BY 'average_answer_score' DESC) AS Rank, UserId AS "user_link", Answers, 'average_answer_score' FROM UserAvgAnswerScore ORDER BY 'average_answer_score' DESC LIMIT 500