0

Please login or register to vote for this query.

(click on this box to dismiss)

Users with highest downvote to upvote ratio.

Q&A for peer programmer code reviews

select top 100
  row_number() over (order by u.DownVotes * 1.0 / u.UpVotes desc) as '#',
  u.Id as [User Link],
  format(u.DownVotes * 1.0 / UpVotes, 'p') as Ratio,
  u.UpVotes as Up,
  u.DownVotes as Down,
  u.Reputation as Rep,
  u.LastAccessDate as LastAccess,
  (
    select top 3
      t.TagName + ', ' as 'data()'
    from
      Posts as p
    inner join
      PostTags as pt on pt.PostId = p.Id
    inner join
      Tags as t on pt.TagId = t.Id
    where
      p.OwnerUserId = u.Id
    group by
      TagName
    for xml path('')
  ) as TopTags
from
  Users as u
where
  u.DownVotes + u.UpVotes > 100
order by
  u.DownVotes * 1.0 / u.UpVotes desc

view current version

edited apr 13 15

created apr 13 15 Athari