Populist Badge Progess

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

Moderators

Q&A for community managers, administrators, and moderators

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 [Score Ratio],
            (( AcceptedAnswer.Score * 2 ) - YourAnswer.Score )               AS [Votes Needed]
    
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 AcceptedAnswer.Score          > 10
            
ORDER BY    [Votes Needed]

Enter Parameters

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