The daily rate of reputation received
Q&A for people studying math at any level and professionals in related fields
-- Reputation Per Day -- The daily rate of reputation received -- I need to remove the hard coding of the date! select DisplayName, Reputation, DATEDIFF(dd, CreationDate, '2010-07-31') as Days_on_SO, (Reputation / DATEDIFF(dd, CreationDate, '2010-07-31')) as Rep_per_day from Users where DATEDIFF(dd, CreationDate, '2010-07-31') > 1 order by Rep_per_day desc