0

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

Q&A for people looking to bypass life's everyday problems with simple tricks

-- 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

view current version

edited feb 20 12 anonymous

created jul 8 10 jon.doe