0

Please login or register to vote for this query.

(click on this box to dismiss)

Unfortunately, includes inactive days between account creation and last access.

Q&A for speakers of other languages learning English

-- Average reputation per day
-- Unfortunately, includes inactive days between account creation and last access.

select
  count(*),
  avg(reputation),
  avg(1 + datediff(day, creationdate, lastaccessdate)),
  avg(reputation / (1 + datediff(day, creationdate, lastaccessdate)))
from users
where reputation > 1

fork query

created sep 23 10 Roger Pate