instruction: Average Reputation Per User Per Day.
response: SELECT (Reputation / DATEDIFF(DAY, CreationDate, GETDATE())) AS DailyAvg, COUNT(*) AS UserCount FROM Users WHERE (Reputation / DATEDIFF(DAY, CreationDate, GETDATE())) > 0 GROUP BY (Reputation / DATEDIFF(DAY, CreationDate, GETDATE())) ORDER BY (Reputation / DATEDIFF(DAY, CreationDate, GETDATE())) DESC