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

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

-- 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 sites:
loading Hold tight while we fetch your results