Lists the top 400 users ordered by the average reputation gained per day (total reputation divided by days of membership).
Q&A for professional and enthusiast programmers
DECLARE @today date SELECT @today = GetDate() SELECT TOP 400 Id AS [User Link], Reputation / DATEDIFF(day, CreationDate, @today) AS DailyReputation, RANK() OVER(ORDER BY Reputation / DATEDIFF(day, CreationDate, @today) DESC) AS Rank FROM Users WHERE Reputation > 5000 ORDER BY DailyReputation DESC