0

Please login or register to vote for this query.

(click on this box to dismiss)

Computes the ratio of number of answers to up votes cast. Does not consider down votes and ignores users who have not up-voted at all.

Q&A for scientific skepticism

-- Answer-to-UpVotesCast Ratio for top 100 answerers (by answer count)
-- Computes the ratio of number of answers to up votes cast.
-- 
-- Does not consider down votes and ignores users who have not up-voted at all.

select
  Id as [User Link],
  Answers,
  UpVotes as "Up votes",
  cast(Answers as numeric) / UpVotes as Ratio
from
  Users
inner join
  (select top 100
     OwnerUserId,count(Id) as Answers
     from Posts
     where PostTypeId = 2  --Only Answers
     group by OwnerUserId
     order by Answers desc
  ) as postCount
on postCount.OwnerUserId = Users.Id
where
  UpVotes > 0
order by
  ratio desc

view current version

edited may 8 12

created jun 15 11 Isaac