Most upvoteable Answers: Answers with highest Vote/View ratio.

1

Please login or register to vote for this query.

(click on this box to dismiss)

Answers with the highest Vote/View ratio among all answers on a question with X views.

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

declare @minViews numeric = ##MinimumViews##

SELECT TOP 500
    answer.Id as [Post Link],
    answer.OwnerUserId as [User Link],
    answer.Score,
    question.ViewCount as [Views],
    Cast(1.0 * question.ViewCount / answer.Score AS DECIMAL(20, 3)) as [Views per Vote]
FROM posts AS answer, posts AS question
WHERE answer.ParentId = question.Id and
      answer.Score > 0 and
      question.ViewCount > @minViews
ORDER BY [Views per Vote] asc

Enter Parameters

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