Q&A for professional and enthusiast programmers
SELECT u.Reputation, COUNT(*) FROM Posts p INNER JOIN Users u ON u.Id = p.OwnerUserId WHERE ClosedDate IS NOT NULL GROUP BY u.Reputation ORDER BY u.Reputation