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.

Q&A for SharePoint enthusiasts

-- 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

fork query

created sep 23 10 Roger Pate