Os usuários mais mão-de-vaca do site

0

Please login or register to vote for this query.

(click on this box to dismiss)

A query não é perfeita mas dá uma noção dos usuário que mais receberam votos e menos votaram em proporção.

Stack Overflow

Q&A for professional and enthusiast programmers

-- 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 1000
  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 > 4000
order by
  ratio desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results