Distribution of the owners of the generalist badge by their estimated rep at the time of getting the

1

Please login or register to vote for this query.

(click on this box to dismiss)

Blender Meta

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

WITH Raw AS (
  SELECT
    Posts.OwnerUserId AS [User Link],
    SUM(
      CASE
        WHEN Votes.VoteTypeId = 1 THEN 15
        WHEN Votes.VoteTypeId = 2 THEN 10
        ELSE -2
      END
    ) AS EstRep
  FROM Posts, Votes, Users, Badges
  WHERE
    Badges.Name = 'Generalist'
    AND
    Badges.TagBased = 0
    AND
    Badges.UserId = Users.Id
    AND
    Posts.OwnerUserId = Users.Id
    AND
    Posts.PostTypeId BETWEEN 1 AND 2
    AND
    Posts.CommunityOwnedDate IS NULL
    AND
    Posts.Id = Votes.PostId
    AND
    Votes.VoteTypeId BETWEEN 1 AND 3
    AND
    Votes.CreationDate < Badges.Date
  GROUP BY Posts.OwnerUserId
)
SELECT
  1000 * FLOOR(0.001 * EstRep) AS EstRepK,
  COUNT(*) AS Count
FROM Raw
GROUP BY 1000 * FLOOR(0.001 * EstRep)
ORDER BY EstRepK

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results