Average reputation per answer for top users


Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

with AUsers as (
    select OwnerUserId as Id,
           Sum(Posts.Score) as Score,
           Count(Posts.Id) as AnswerCount
    from Posts
    where PostTypeId = (Select id from PostTypes where Name = 'Answer')
    and OwnerUserId = 9122
    group by OwnerUserId
    having Count(Posts.Id) > 10
    top 500
    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

Switch to main site
loading Hold tight while we fetch your results