Top 400 by average daily reputation

1

Please login or register to vote for this query.

(click on this box to dismiss)

Lists the top 400 users ordered by the average reputation gained per day (total reputation divided by days of membership).

Super User

Q&A for computer enthusiasts and power users

DECLARE @today date
SELECT @today = GetDate()

SELECT TOP 400
  RANK() OVER(ORDER BY Reputation / DATEDIFF(day, CreationDate, @today) DESC) AS Rank,
  Id AS [User Link],
  Reputation / DATEDIFF(day, CreationDate, @today) AS DailyReputation
FROM
  Users
WHERE
  Reputation > 5000
ORDER BY 
  DailyReputation DESC

Enter Parameters

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