What reputation do people with Favorite/Stellar Question badges typically have?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

--This query will produce a cumulative distribution of the current reputations
--of users that have earned Favorte/Stellar Question badges. Specifically, it 
--takes a favorite count threshold and finds the reputation of the askers of 
--all questions with that count (25 for Favorite and 100 for Stellar Question).
--This is presented as a graph of the number of users on that list with up to
--the reputation on the horizontal axis.

SELECT
  Users.Reputation AS Rep, 
  ROW_NUMBER() OVER(ORDER BY Users.Reputation) AS NumberOfUsers
FROM
  Posts
  INNER JOIN Users
  ON Posts.OwnerUserId=Users.Id
WHERE
  (
    Posts.PostTypeId=1 --questions
    AND
    Posts.FavoriteCount>##FavoriteCountThreshold##
    AND
    Users.Reputation<##repThreshold?1000000##
  )

Enter Parameters

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