0

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 about the site for scholars and enthusiasts of literature

-- 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],
  round((Upvotes * 1.0 / Downvotes), 2) as [Upvotes per Downvote],
  UpVotes as [+ Votes],
  DownVotes [- Votes]
from Users
where Reputation > ##MinRep##
and Downvotes > 0
order by [Upvotes per Downvote] asc

fork query

created feb 18 11 oid