Users with the lowest up/down vote ratio
Q&A for professional and enthusiast programmers
-- Angriest Users -- Users with the highest down/up vote ratio SELECT Id AS [User Link], Reputation, UpVotes /CONVERT(float, DownVotes) as du_ratio, DownVotes, UpVotes, (DownVotes+UpVotes) as totalVotes FROM Users WHERE Reputation > 1000 -- they have to be allowed to downvote and DownVotes > 1 and UpVotes > 1 ORDER BY DownVotes