Downvoters Hall of Shame (by percentage)

0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 100 downvoters by percentage

Stack Overflow на русском

Q&A for программистов

-- 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  DownVotes > 20     -- Suppress lower vote counts; 
 AND Id <> -1 -- these are habitual downvoters.
ORDER BY DownVotesPCT DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results