Biggest DownVoters

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Biggest DownVoters

SELECT TOP ##MaxNumUsers:int?100##
  
  ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [# by Rep],
  Id as [User Link],
  ROW_NUMBER() OVER(ORDER BY DownVotes DESC) AS [# by DownVotes],
  
  UpVotes as [Up Votes],
  DownVotes [Down Votes],
  UpVotes - DownVotes as [Net Votes],
  
  ROUND((100.0 * DownVotes / (UpVotes + DownVotes) ), 2) as [Down Votes PCT],
  
  Reputation
  
  FROM Users
  WHERE DownVotes > ##DownVotesGreaterThan:int?1##
   and UpVotes >= ##MinUpVotes:int?1##
   and Reputation >= ##MinReputation:int?50000##
   
   
  --ORDER BY [Down Votes PCT] DESC, [Net Votes] DESC
  
  -- Alternate ordering
  --ORDER BY [Net Votes] ASC, [Down Votes PCT] DESC
  ORDER BY [Down Votes PCT] DESC, [Down Votes] DESC

Enter Parameters

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