Score-per-thousand-views per answer (ranking; non-CW)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select rank() over (order by R.RawRatio * R.Ratio desc) as Rank, R.Id as [User Link]
    , R.Ratio, R.TotalScore, R.NumAnswers, R.RawRatio
    , sqrt(R.RawRatio * 0.5*(R.Ratio + abs(R.Ratio))) as Combined
from (
  select U.Id
    , sum(1000 * cast(A.Score as real) / Q.ViewCount) / count(A.Id) as Ratio
    , sum(A.Score) as TotalScore
    , count(A.Id) as NumAnswers
    , sqrt(0.5*(sum(A.Score) + abs(sum(A.Score)))) / count(A.Id) as RawRatio 
  from Posts A
  inner join Posts Q on Q.Id = A.ParentId
  inner join Users U on U.Id = A.OwnerUserId
  where A.PostTypeId = 2
    and A.CommunityOwnedDate is null
  group by U.Id, U.Reputation
  having count(A.Id) >= ##MinimumAnswerCount?150##
  ) R
where R.RawRatio >= ##MinimumRawRatio?0## -- 2 for raw
order by Combined desc

Enter Parameters

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