Top Users by Reputation Per Day

0

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

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

-- 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,
       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