instruction: Top 100 users by average normalized score. Users who have the highest share in total score received by all answers to the questions they answered
  (among users with >100 eligible answers, includes answers with score >=0 and questions with total score of answers >0)
response: SELECT u.Id AS "user_link", AVG(a.NormalizedScore) AS AvgNormalizedScore FROM Users AS u JOIN (SELECT (CAST(a.Score AS FLOAT) / SUM(allA.Score)) * 100 AS NormalizedScore, a.Id, a.OwnerUserId FROM Posts AS a JOIN Posts AS q ON a.ParentId = q.Id JOIN Posts AS allA ON allA.ParentId = q.Id WHERE a.PostTypeId = 2 AND a.Score >= 0 AND allA.Score > 0 GROUP BY a.Id, a.OwnerUserId, a.Score HAVING SUM(allA.Score) > 0) AS a ON a.OwnerUserId = u.Id GROUP BY u.Id HAVING COUNT(a.Id) > 100 ORDER BY AvgNormalizedScore DESC LIMIT 100