Average reputation per account day

0

Please login or register to vote for this query.

(click on this box to dismiss)

Includes inactive days between account creation and last access, as visited days is not public.

Stack Overflow

Q&A for programmers

-- Average reputation per account day
-- Includes inactive days between account creation and last access, as visited days is not public.

create table #rep_cutoff (
  min_rep int
)
insert into #rep_cutoff values
(1), (2), (50), (100), (1000), (2500), (5000), (7500), (10000), (20000), (40000), (80000), (100000);

with total (users) as (select count(*) from users where reputation > 1)

select
  count(*) "Users",
  min_rep "Rep Cutoff",
  round(avg(reputation / (1.0 + datediff(day, creationdate, lastaccessdate))), 2) "Avg Rep/Day",
  round(100.0 * count(*) / total.users, 3) "% 'Real' Users"
from users, #rep_cutoff, total
where reputation >= min_rep
group by min_rep, users
order by min_rep

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached