My stinginess

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.

Physics

Q&A for active researchers, academics and students of physics

-- My stinginess
-- 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.

declare @UserId int = ##UserId##

select 
  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
  and Id = @UserId

Enter Parameters

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