Shooting stars

1

Please login or register to vote for this query.

(click on this box to dismiss)

Accounts less then a week old with the most reputation earned per day.

Stack Overflow

Q&A for professional and enthusiast programmers

-- Shooting stars
-- Accounts less then a week old with the most reputation earned per day.
SELECT TOP 500
    Id AS [User Link],
    Reputation AS Reputation,
    Reputation /(DateDiff(Day, Users.CreationDate, Users.LastAccessDate)) AS [Rep Per Day],
    DateDiff(Day, Users.CreationDate, Users.LastAccessDate) AS [Account Age]
    FROM Users
    WHERE DateDiff(Day, Users.CreationDate, Users.LastAccessDate) < 7 AND
    DateDiff(Day, Users.CreationDate, Users.LastAccessDate) > 0
ORDER BY [Rep Per Day] DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results