0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions where your answer has at least twice the score of the accepted answer which in turn must have a score of 9 or higher

Q&A for active researchers, academics and students of physics

SELECT
    Question.Id as [Post Link],
    AcceptedAnswer.Score as [Accepted Score],
    YourAnswer.Score as [Your Score],
    CONVERT(DECIMAL(4,2), CAST(YourAnswer.Score as float) / AcceptedAnswer.score) as ScoreRatio,
    AcceptedAnswer.Score * 2 - YourAnswer.Score as VotesNeeded
FROM
    Posts Question,
    Posts AcceptedAnswer,
    Posts YourAnswer,
    Users AcceptedUser
WHERE
    YourAnswer.OwnerUserId = ##UserId##
    and YourAnswer.ParentId = Question.Id
    and Question.AcceptedAnswerId = AcceptedAnswer.Id
    and AcceptedAnswer.OwnerUserId = AcceptedUser.Id
    and AcceptedAnswer.Id != ##UserId##
    and YourAnswer.Score > AcceptedAnswer.Score
    and AcceptedAnswer.Score > 0
    
ORDER BY VotesNeeded DESC

fork query

edited dec 23 13 Code Maverick

created apr 19 11 oid