Negative Vibrations - Users sorted by their Downvote / Upvote Ratio.

1

Please login or register to vote for this query.

(click on this box to dismiss)

Top 100 Users with a specified minimum rep, measured by their Number of Upvotes per Downvote (lowest first). Example (MinRep): (2000).

Stack Overflow

Q&A for professional and enthusiast programmers

-- Negative Vibrations - Users sorted by their Downvote / Upvote Ratio.
-- Top 100 Users with a specified minimum rep, measured by their
-- Number of Upvotes per Downvote (lowest first).
-- Example (MinRep): (2000).

select top 100
  id as [User Link],
reputation as Rep,
  round((Upvotes * 1.0 / Downvotes), 2) as [Upvotes per Downvote],
  UpVotes,
  DownVotes
from Users
where Reputation > ##MinRep##
and Users.id > 0
and Downvotes > 0
order by [Upvotes per Downvote] asc

Enter Parameters

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