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.

The Great Outdoors

Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

-- 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 to meta site
loading Hold tight while we fetch your results