instruction: Users with the Highest Score in the Git Tag.
response: SELECT ROW_NUMBER() OVER (ORDER BY Score DESC) AS Rank, Id AS "user_link", Score, 'count' AS "# Answers" FROM (SELECT u.Id, SUM(a.Score) AS Score, COUNT(a.Score) AS "Count" FROM Posts AS q INNER JOIN Posts AS a ON q.Id = a.ParentId INNER JOIN PostTags AS t ON q.Id = t.PostId INNER JOIN Users AS u ON u.Id = a.OwnerUserId WHERE t.TagId = 119 GROUP BY u.Id HAVING SUM(a.Score) >= 1000) AS X ORDER BY Score DESC