% Answers by author account age by week last 180 days


Please login or register to vote for this query.

(click on this box to dismiss)

Operations Research Meta

Q&A about the site for operations research and analytics professionals, educators, and students

with AnswersByMonth as
select dateadd(week, datediff(week, 0, a.CreationDate), 0) mo,
  count(*) Answers
from Posts a
where PostTypeId=2
and CreationDate > getdate()-180
group by dateadd(week, datediff(week, 0, a.CreationDate), 0)

select mo,
  cast(datediff(week, u.CreationDate, a.CreationDate)/12 as varchar(8)) AccountAgeYears, 
  count(*)*100.0/Answers PctAnswers
from Posts a
join AnswersByMonth abm on abm.mo=dateadd(week, datediff(week, 0, a.CreationDate), 0)
join Users u on u.Id=a.OwnerUserId and u.CreationDate < a.CreationDate
where PostTypeId=2
and a.CreationDate > getdate()-180
group by mo, datediff(week, u.CreationDate, a.CreationDate)/12, Answers
order by mo

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results