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 )