Reputation to Post Ratio

0

Please login or register to vote for this query.

(click on this box to dismiss)

Display, in descending order, the rep-to-post ratio of users with at least MinRep

Stack Overflow

Q&A for programmers

-- Reputation to 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 Reputation DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached