shows your accepted answers and how close they are to earning the Guru badge (accepted answer and score of 40 or more)
Q&A about the site for serious players and enthusiasts of chess
select Answer.Id as [Post Link], Answer.Score, CAST(CONVERT(DECIMAL(5,2), Answer.Score * 2.5) as VARCHAR(6)) + '%' as GuruProgress from Posts as Question LEFT JOIN Posts as Answer on Question.AcceptedAnswerId=Answer.Id WHERE Question.PostTypeId=1 and Answer.OwnerUserId=##UserID:int## and Answer.CommunityOwnedDate is null ORDER BY Answer.Score DESC