Percentage of high-rep users by join date

0

Please login or register to vote for this query.

(click on this box to dismiss)

For a given month, what percentage of users are "High Reputation" users?

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @highRep INT = ##HighScore:int?1000##;

SELECT      DATEADD( MONTH, DATEDIFF( MONTH, 0, u.CreationDate ), 0 ) AS Date
            , SUM( CASE WHEN u.Reputation > @highRep THEN 1 ELSE 0 END )
            AS [High Rep %]
FROM        Users u
GROUP BY    DATEADD( MONTH, DATEDIFF( MONTH, 0, u.CreationDate ), 0 )
ORDER BY    DATEADD( MONTH, DATEDIFF( MONTH, 0, u.CreationDate ), 0 )

Enter Parameters

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