0

Please login or register to vote for this query.

(click on this box to dismiss)

Computes the ratio of total reputation to up vote rep, to reveal the users who have gained more reputation than they have distributed to the community. Users must have more than 1000 rep. Does not consider down votes, ignores the fact that questions only receive 5 rep points, ignores accepted answer rep and bounties, and ignores users who have not up-voted at all. + Ignore the Community as a valid user

Q&A about the site for followers of the Hindu religion and those interested in learning more about Hinduism

-- Top 50 most stingy power users
-- Computes the ratio of total reputation to up vote rep, to reveal the users who have gained more reputation than they have distributed to the community.
-- 
-- Users must have more than 1000 rep. Does not consider down votes, ignores the fact that questions only receive 5 rep points, ignores accepted answer rep and bounties, and ignores users who have not up-voted at all.

select top 50
  Id as [User Link],
  Reputation,
  DownVotes as "Down Votes"
from
  Users
where
  DownVotes > 0
  and
  Reputation > 0
  and
  ID > 0 
order by
  DownVotes desc

fork query

edited jul 28 anonymous

created jun 9 11 sblair