High-Rep Users by Reputation Per Day

0

Please login or register to vote for this query.

(click on this box to dismiss)

High rep users based on the amount of reputation they have earned per day

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

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) AND 
      (Reputation>=10000)
ORDER BY Reputation DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results