Average reputation per answer for top users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

Select
    top 200
    ROW_NUMBER () OVER( order by 1.0 * Reputation / 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 * Reputation / 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

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