Q&A for community managers, administrators, and moderators
select rank() over (order by R.CombinedRatio desc) as Rank, R.Id as [User Link] , R.CombinedRatio, R.SVRatio, R.ScoreRatio, R.TotalScore, R.NumAnswers from ( select U.Id , sum(A.Score) as TotalScore , count(A.Id) as NumAnswers , sum(1000 * cast(A.Score as real) / Q.ViewCount) / count(A.Id) as SVRatio , cast(sum(A.Score) as real) / count(A.Id) as ScoreRatio , sum(1000 * power((cast(A.Score as real) + abs(A.Score))/2, 0.75) / sqrt(Q.ViewCount)) / count(A.Id) as CombinedRatio 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.ScoreRatio >= ##MinimumScoreRatio?0## order by R.CombinedRatio desc