Reputation per day leaderboard

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

DECLARE @DumpDate DateTime
-- From rene's answer here: https://meta.stackexchange.com/a/361312/165261
SET @DumpDate = (select create_date from sys.tables where object_id = object_id('Users'))

SELECT TOP 1000
  Id as [User Link],
  DATEDIFF(day, CreationDate, @DumpDate) as [Days on Site],
  Reputation,
  CAST(Reputation as decimal)/DATEDIFF(day, CreationDate, @DumpDate) as [Rep per Day]
FROM Users
WHERE DATEDIFF(day, CreationDate, @DumpDate) >= 7 -- Gotta be here at least a week
ORDER BY [Rep per Day] DESC

Enter Parameters

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