Top Users by Reputation Per Day

1

Please login or register to vote for this query.

(click on this box to dismiss)

The top 100 users based on the amount of reputation they have earnt per day

Stack Overflow

Q&A for professional and enthusiast programmers

-- Top Users by Reputation Per Day
-- The top 100 users based on the amount of reputation they have earnt per day

SELECT TOP 100
       Id as [User Link],
       DisplayName, 
       Reputation, 
       DATEDIFF(dd, CreationDate, getdate()) as DaysActive, 
       (Reputation / DATEDIFF(dd, CreationDate, getdate())) as RepPerDay 
FROM Users
WHERE DATEDIFF(dd, CreationDate, getdate()) > 0
ORDER BY RepPerDay DESC

Enter Parameters

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