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

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

fork query

edited nov 7 17 Mooz

created aug 9 16 René Vogt