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?

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 )

fork query

edited apr 26 15 anonymous

created apr 25 15 Brock Adams