0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 100 downvoters by percentage

Q&A for people looking to bypass life's everyday problems with simple tricks

-- Downvoters Hall of Shame (by percentage) 
-- The top 100 downvoters by percentage

SELECT TOP 100
    Id as [User Link],
    UpVotes,
    DownVotes,
    (DownVotes)*100/(DownVotes+UpVotes) as DownVotesPCT
FROM Users
WHERE UpVotes > 20 AND DownVotes > 20     -- Suppress lower vote counts; 
 AND UpVotes+DownVotes > 100 AND Id <> -1 -- these are habitual downvoters.
 and DisplayName like 'R%'
ORDER BY DownVotesPCT DESC

fork query

edited oct 29 12 jon.doe7045

created apr 18 11 anonymous