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 for those who study, teach, research and apply economics and econometrics

-- 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 = ##id##
ORDER BY Ratio DESC

fork query

edited feb 10 12

created jan 9 12 anonymous