2

Please login or register to vote for this query.

(click on this box to dismiss)

Users who received lots of reputation of very few posts. -- Threshold: Reputation Threshold

Q&A for professional and enthusiast programmers

select top 1000
  u.Id as [User Link],
  u.Reputation,
  sum(p.Score) / count(p.Id) as [Luck],
  u.LastAccessDate [Last Access]
from
  Posts p
inner join
  Users u on p.OwnerUserId = u.Id
where
  p.PostTypeId in (1, 2) -- question or answer
  and p.CommunityOwnedDate is null
group by
  u.Id,
  u.Reputation,
  u.LastAccessDate
having 1=1
  --and sum(p.Score) / count(p.Id) > 100
  and count(p.Id) < 10
  and u.Reputation > ##Threshold:int?10000##
order by
  sum(p.Score) / count(p.Id) desc

fork query

edited apr 22 16

created apr 22 16 Athari