Age-normalised score per answer (ranking; non-CW)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

select top ##RankedUsers?1000##
  rank() over (order by R.Ratio desc) as Rank, R.Id as [User Link], R.Ratio
from (
select U.Id, 100 * sum(cast(A.Score as real) / datediff(day, A.CreationDate, getdate())) / count(A.Score) as Ratio
  from Posts A
  inner join Users U on U.Id = A.OwnerUserId
  where A.PostTypeId = 2
    and A.CommunityOwnedDate is null
  group by U.Id
  having count(A.Id) >= ##MinimumAnswerCount?400##
  ) R
order by R.Ratio desc

Enter Parameters

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