instruction: Count of posts' and votes' sorted by rep.
response: SELECT u.DisplayName, u.Reputation, u.UpVotes, u.DownVotes, q.QuestionsCount, a.AnswersCount, u.Reputation / a.AnswersCount AS RepPerAnswer FROM Users AS u JOIN (SELECT COUNT(1) AS QuestionsCount, OwnerUserId FROM Posts WHERE PostTypeId = 1 GROUP BY OwnerUserId) AS q ON u.Id = q.OwnerUserId JOIN (SELECT COUNT(1) AS AnswersCount, OwnerUserId FROM Posts WHERE PostTypeId = 2 GROUP BY OwnerUserId) AS a ON u.Id = a.OwnerUserId ORDER BY u.Reputation DESC