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).

Q&A for anime and manga fans

-- 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

fork query

created feb 18 11 oid