instruction: Who can achieve the most reputation with one answer in his lifetime in SO?. Who can achieve the most reputation with one answer in his lifetime in SO?
response: SELECT Users.Id AS "user_link", Users.Reputation AS UserReputation, Posts.Score AS PostScore FROM Users INNER JOIN Posts ON Posts.OwnerUserId = Users.Id WHERE Posts.PostTypeId = 2 AND (SELECT COUNT(Posts.Id) FROM Posts WHERE OwnerUserId = Users.Id) = 1 AND Users.Reputation > 10000 ORDER BY UserReputation DESC