Top 400 by average daily reputation

0

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).

Stack Overflow

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

Enter Parameters

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