3

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

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

fork query

created nov 11 11 NullUserException