Display, in descending order, the rep-to-post ratio of users with at least MinRep
Q&A for users and developers of hardware and software for Raspberry Pi
-- Reputation per Post Ratio -- Display, in descending order, the rep-to-post ratio of users with at least MinRep SELECT DisplayName, PostCount, Reputation, Reputation*1.0/PostCount as Ratio FROM Users INNER JOIN (SELECT OwnerUserId, COUNT(*) AS PostCount FROM Posts GROUP BY OwnerUserId ) x ON OwnerUserId = Id WHERE Reputation > ##MinRep## ORDER BY Ratio DESC