6

Please login or register to vote for this query.

(click on this box to dismiss)

Top Users sorted by their average daily reputation

Q&A about the site for expert genealogists and people interested in genealogy or family history

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

fork query

created feb 25 11 oid