Downvote ratio for great voters with significant reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Downvote ratio for great voters with significant reputation

Mythology

Q&A for enthusiasts and scholars of mythology and folklore

DECLARE @reputation AS INT; SET @reputation = 2000
DECLARE @votes AS INT; SET @votes = 2000

-- Ratio of DV from the top voters

SELECT Id as [User Link],
       (UpVotes + DownVotes) AS 'Total Votes',
       ROUND((DownVotes * 100.0) / (UpVotes + DownVotes + 1), 2) AS '% DOWN Votes',
       UpVotes AS 'UP Votes', 
       DownVotes AS 'DOWN Votes',
       Reputation
FROM Users
WHERE (UpVotes + DownVotes) > @votes
      AND Reputation > @reputation
      ORDER BY 'Total Votes' DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results