Average reputation per answer for top users


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

    top 200
    ROW_NUMBER () OVER ( order by 1.0 * Sum(Posts.Score) / Count(Posts.Id) desc ) as [Rank],
    Users.Id as [User Link],
    Users.DisplayName as [User Name],
    Reputation as [Total Reputation],
    Count(Posts.Id) as [AnswerCount],
    Convert(Decimal(8,2), (1.0 * Sum(Posts.Score)) / Count(Posts.Id)) as [Rep/Answer]
from Users
    join Posts on Posts.OwnerUserID = Users.Id
where PostTypeId = (Select id from PostTypes where Name = 'Answer')
group by Posts.OwnerUserID, Users.Id, Users.DisplayName, Reputation
order by [Rep/Answer] desc;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results