Who has cast the most downvotes?

0

Please login or register to vote for this query.

(click on this box to dismiss)

This query doesn't care how many votes you've cast overall (though it does display your percentage) but rather it looks at the total number of downvotes.

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

-- Who has cast the most downvotes?
-- This query doesn't care how many votes you've cast overall (though it does display your percentage) but rather it looks to see the total number of downvotes.
select top 500 
  Id as [User Link],
  (SELECT SUM (DownVotes) FROM Users),
  UpVotes,
  DownVotes,
  ((DownVotes*100) / (SELECT SUM (DownVotes) FROM Users) )  As PercentageDown,
  ((UpVotes*100) / (SELECT SUM (UpVotes) FROM Users) )  As Percentageup
  from Users c  
where DownVotes > 1
order by DownVotes desc

Enter Parameters

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