0

Please login or register to vote for this query.

(click on this box to dismiss)

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

Q&A about the site for members of the workforce navigating the professional setting

-- Enter Query Title
-- Enter Query Description

    SELECT DisplayName, PostCount, TotalScore, 
           TotalScore*1.0/PostCount as Ratio
      FROM Users 
INNER JOIN

(SELECT OwnerUserId, COUNT(*) AS PostCount, SUM(Score) As TotalScore
       FROM Posts
   GROUP BY OwnerUserId ) x

      ON OwnerUserId = Id
   WHERE Reputation > ##MinRep##
ORDER BY Ratio DESC

fork query

created nov 12 11 NullUserException