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 science fiction and fantasy enthusiasts
-- 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