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.
Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
-- 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, UpVotes as "Up votes", cast(Reputation as numeric) / (10.0 * UpVotes) as Ratio, cast(Reputation as numeric) - (10.0 * UpVotes) as Difference from Users where UpVotes > 0 and Reputation > 1000 order by ratio desc