Q&A for programming puzzle enthusiasts and code golfers
-- How close am I to the Sportsmanship Badge -- Posts that allow you to get the sportsmanship badge by voting on them. -- This gives you an idea if you can even get this badge. -- It is not possible to show your progress toward the badge because -- the data is cleansed of any upvote information tied to a userId. -- This gives you a list of answers you can upvote (if you like them). -- If there is not 100 items in this list, you can't get the badge. WITH CandidatePosts AS ( select ParentId postId from posts p where p.OwnerUserId = ##UserId## and p.postTypeId = 2 and p.score >= 0 ) select p1.id as [Post Link], p1.ownerUserId as [User Link], body from posts p1 join CandidatePosts cp on cp.postId = p1.parentId where p1.ownerUserId <> ##UserId## and p1.Score = 2 order by p1.Score DESC