What questions does Jon Skeet have a higher/lower score on than me?
Q&A for science fiction and fantasy enthusiasts
-- Jon Skeet comparison -- What questions does Jon Skeet have a higher/lower score on than me? declare @UserId int = ##UserId##; with fights as ( select myAnswer.ParentId as Question, myAnswer.Score as MyScore, jonsAnswer.Score as JonsScore from Posts as myAnswer inner join Posts as jonsAnswer on jonsAnswer.OwnerUserId = 22656 and myAnswer.ParentId = jonsAnswer.ParentId inner join Posts as Post on Post.Id = myAnswer.ParentId where myAnswer.ownerUserId = @UserId and myAnswer.postTypeId = 2 and Post.AcceptedAnswerID = myAnswer.ownerUserId ) select case when myScore > JonsScore then 'You win' when myScore < JonsScore then 'Jon wins' else 'Tie' end as 'Winner', Question as [Post Link], myScore as 'My score', jonsScore as "Jon's score" from fights;