Progress towards Reversal badge


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @user INT = ##UserID:int##

    Answer.Id as [Post Link],
    CASE WHEN Answer.Score >= 20 then 'Reversal!' else CONVERT(INT, CAST(Answer.Score as float) * 100 / 20) END as IsReversal
FROM Posts as Answer
LEFT JOIN Posts as Question on Answer.ParentId=Question.Id
WHERE Answer.OwnerUserId=@user and Question.Score <= -5
ORDER BY Answer.Score DESC

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results