Includes inactive days between account creation and last access, as visited days is not public.
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