Reputation per post

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

Network Engineering

Q&A for network engineers

-- 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 to meta site
loading Hold tight while we fetch your results