Rising stars, top 50 users ordered on rep per day

Looking at the duration from when a user created their account till
the last post, who gained the most rep per day

Q&A for sound designers

-- Rising stars, top 50 users ordered on rep per day
-- Looking at the duration from when a user created their account till
-- the last post, who gained the most rep per day
set nocount on
DECLARE @endDate date
SELECT @endDate = max(CreationDate) from Posts
set nocount off
SELECT TOP 50
Id AS [User Link], Reputation, Days,
Reputation/Days AS RepPerDays
FROM (
SELECT *,
CONVERT(int, @endDate - CreationDate) as Days
FROM Users
) AS UsersAugmented
WHERE
Reputation > 5000
ORDER BY
RepPerDays DESC