Q&A about the site for serious players and enthusiasts of chess
DECLARE @user INT = ##UserID:int## select Answer.Id as [Post Link], Answer.Score, 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