Progress towards Reversal badge


Please login or register to vote for this query.

(click on this box to dismiss)

Game Development

Q&A for professional and independent game developers

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

    Answer.Id as [Post Link],
    CASE WHEN Answer.Score >= 20 then 'Reversal!' else CAST(CONVERT(INT, CAST(Answer.Score as float) * 100 / 20) as VARCHAR(2)) + '%' END as Progress
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