Q&A about the site for enthusiasts and power users of the Android operating system
WITH a AS ( SELECT OwnerUserId, CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END Upvote, CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END Downvote, CASE WHEN PostTypeId = 1 THEN 1 ELSE 0 END Questionvote, CASE WHEN PostTypeId = 2 THEN 1 ELSE 0 END Answervote FROM Posts p INNER JOIN Votes v ON v.PostId = p.Id ) Select top 20000 (sum(Answervote*(Upvote-Downvote))) as AnswerScore, -- OwnerUserId As [User Link], (sum(Questionvote*(Upvote-Downvote))) as QuestionScore from a Group By OwnerUserId Order By sum(Answervote*(Upvote-Downvote)) desc