What questions does Jon Skeet have a higher/lower score on than me?
Q&A about the site for aircraft pilots, mechanics, and enthusiasts
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 where myAnswer.ownerUserId = @UserId and myAnswer.postTypeId = 2 ) 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;