1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

--This query will produce a cumulative distribution of the current reputations
--of users that have earned popular-question-series badges. Specifically, it 
--takes a views threshold and finds the reputation of the askers of all 
--questions with that many views (1,000 for Popular, 2,500 for Notable, and 
--10,000 for Famous 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.ViewCount>##viewsThreshold##
    AND
    Users.Reputation<##repThreshold?1000000##
  )

fork query

edited dec 8 13

created dec 8 13 anonymous