Average reputation per answer for top users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

with AUsers as (
    select OwnerUserId as Id,
           Sum(Posts.Score) as Score,
           Count(Posts.Id) as AnswerCount
    from Posts
    where PostTypeId = 2
    group by OwnerUserId
    having Count(Posts.Id) > 10
)
Select
    ROW_NUMBER () OVER ( order by 1.0 * AUsers.Score / AnswerCount desc ) as [Rank],
    Users.Id as [User Link],
    Users.DisplayName as [User Name],
    Reputation as [Total Reputation],
    AnswerCount as [AnswerCount],
    Convert(Decimal(8,2), (1.0 * AUsers.Score) / AnswerCount) as [Rep/Answer]
from Users
    join AUsers on AUsers.Id = Users.Id
order by [Rep/Answer] desc;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results