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.

--declare @rep_cutoff int = 1000
create table #rep_cutoff (
  min_rep int
)
insert into #rep_cutoff values
(1), (2), (100), (1000), (3000), (5000), (7500), (10000), (20000)
  

select
  count(*) "Users",
  min_rep "Rep Cutoff",
  avg(reputation) "Avg Rep",
  avg(1 + datediff(day, creationdate, lastaccessdate)) "Avg Days",
  round(avg(reputation / (1.0 + datediff(day, creationdate, lastaccessdate))), 2) "Avg Rep/Day"
from users, #rep_cutoff
where reputation >= min_rep
group by min_rep
order by min_rep

fork query

created sep 23 10 Roger Pate