Critical Thinkers Club

1

Please login or register to vote for this query.

(click on this box to dismiss)

The top 500 downvoters amongst high voters, sorted on downvotes and percentage

Stack Overflow

Q&A for professional and enthusiast programmers

-- Critical Thinkers Club 
-- The top 500 downvoters, sorted by downvotes and by percentage down

SELECT TOP 500
    Id as [User Link],
    CreationDate,
    Reputation,
    FORMAT(1.0*(DownVotes)/(DownVotes+UpVotes), 'p') as DownVotesPCT,
    DownVotes,
    UpVotes+DownVotes as AllVotes   
    
FROM Users
WHERE  (Upvotes+DownVotes) >= 1000     -- Suppress lower vote counts; 
 AND   Id       <> -1     -- these are habitual downvoters.
ORDER BY DownVotes    DESC, 
         DownVotesPCT DESC

Enter Parameters

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