0

Please login or register to vote for this query.

(click on this box to dismiss)

The daily rate of reputation received

Q&A for people looking to improve their interpersonal communication skills

-- Reputation Per Day
-- The daily rate of reputation received

SELECT TOP 100
       Id,
       DisplayName, 
       Reputation, 
       DATEDIFF(dd, CreationDate, getdate()) as Days_on_SO, 
       (Reputation / DATEDIFF(dd, CreationDate, getdate())) as Rep_per_day 
FROM Users
WHERE DATEDIFF(dd, CreationDate, getdate()) > 0
ORDER BY Rep_per_day DESC

fork query

created jan 13 11 anonymous