1

Please login or register to vote for this query.

(click on this box to dismiss)

We calculate the rep of the users by counting only the up/down/accept votes (so: no bounty, edits, -100 for rudeness, 1 rep limit, community owned posts, -1 for answer downs, no rep for most deleted posts, and no rep for self-answer accepts). Then we see the distribution, how this estimated reputation relates to the real reputation of the users.

Q&A for users, experts, and developers of the Tezos blockchain project

WITH VoteRep AS (
  SELECT 1 AS VoteTypeId, 15 AS Rep
  UNION
  SELECT 2, 10
  UNION
  SELECT 3, -2
),
Raw AS (
  SELECT
    Users.Id,
    SUM(VoteRep.Rep) AS EstRep,
    MIN(Users.Reputation) AS Reputation
  FROM Users, Posts, Votes, VoteRep
  WHERE
    Posts.OwnerUserId = Users.Id
    AND
    Votes.PostId = Posts.Id
    AND
    Votes.VoteTypeId = VoteRep.VoteTypeId
  GROUP BY Users.Id
),
Raw2 AS (
  SELECT Id, 1.0 * EstRep/Reputation AS RatioRaw
  FROM Raw
  WHERE
    EstRep BETWEEN ##MinEstRep:int?1## AND ##MaxEstRep:int?10000000##
    AND
    Reputation BETWEEN ##MinRep:int?1## AND ##MaxRep:int?10000000##
)
SELECT
  FLOOR(RatioRaw/##Delta:float?0.01## + 0.5)*##Delta## AS Ratio,
  COUNT(*) AS Count
FROM Raw2
WHERE RatioRaw BETWEEN ##MinRatio:float?0## AND ##MaxRatio:float?2##
GROUP BY FLOOR(RatioRaw/##Delta## + 0.5)
ORDER BY Ratio

fork query

edited mar 11

created mar 11 peterh - PLEASE DELETE THIS ACCOUNT