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 'Ra%' ORDER BY DownVotesPCT DESC