8

Please login or register to vote for this query.

(click on this box to dismiss)

Users with highest downvote to upvote ratio.

Q&A about the site for music historians, critics, and fans

select top 100
  row_number() over (order by DownVotes * 1.0 / UpVotes desc),
  Id as [User Link],
  format(DownVotes * 1.0 / UpVotes, 'p') as Ratio,
  DownVotes,
  UpVotes,
  Reputation,
  LastAccessDate
from
  Users
where
  DownVotes + UpVotes > 100
order by DownVotes * 1.0 / UpVotes desc

view current version

edited apr 13 15

created apr 13 15 Athari