What reputation do people with Nice/Good/Great Question badges typically have?

0

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 nice-question-series badges. Specifically, it 
--takes a score threshold and finds the reputation of the askers of all 
--questions with that score (10 for Nice, 25 for Good, and 100 for Great 
--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.Score>##scoreThreshold##
    AND
    Users.Reputation<##repThreshold?1000000##
  )

Enter Parameters

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