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

Q&A about the site for practitioners of the art and science of signal, image and video processing

-- 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 OwnerUserId = 541091
ORDER BY Ratio DESC

fork query

edited jan 31 12 berk0081

created jan 9 12 anonymous