Top Users sorted by their average daily reputation
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