Q&A about the site for administrators, end users, developers and designers for Craft CMS
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 ), b AS ( Select top 20000 (sum((Upvote-Downvote))) as TotalScore, (sum(Answervote*(Upvote-Downvote))) as AnswerScore, OwnerUserId, (sum(Questionvote*(Upvote-Downvote))) as QuestionScore from a Group By OwnerUserId Order By sum(Answervote*(Upvote-Downvote)) desc ) Select (1.000*QuestionScore/(1.000*AnswerScore)) from b Where TotalScore < 100 AND AnswerScore>0