Reputation per post

1

Please login or register to vote for this query.

(click on this box to dismiss)

Displays all users with more than 100 posts who have the highest reputation per post

Music Fans Meta

Q&A about the site for music historians, critics, and fans

-- Reputation per post
-- Displays all users with a reputation >= 1000 who have the highest reputation per post

 select top 1000
    *
  from
    (
    select
      u.Id,
      max(u.DisplayName) as DisplayName,
      max(u.Reputation) as Reputation,
      count(p.Id) as TotalPosts,
      max(u.Reputation) / count(p.Id) as ReputationPerPost
    from
      Users u
      inner join Posts p on p.OwnerUserId = u.Id
    group by
      u.Id
    having
      count(p.Id) > 100
    ) as x
  order by
    x.ReputationPerPost desc

Enter Parameters

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