Rep per day

6

Please login or register to vote for this query.

(click on this box to dismiss)

Top Users sorted by their average daily reputation

Drupal Answers

Q&A for Drupal developers and administrators

-- Rep per day
-- Top Users sorted by their average daily reputation

SELECT 
    u.id as [User Link],
    cast(datediff(day, u.creationDate, current_timestamp) as nvarchar) + ' Days'
      as [Member for],
    u.reputation as [Rep],
    (u.reputation / datediff(day, u.creationDate, current_timestamp)) as [Avg rep per Day]
FROM 
    Users u
where
u.reputation > 10000
ORDER BY 
    [Avg rep per Day] DESC

Enter Parameters

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