Active Answerers (3+ Questions) per Week

1

Please login or register to vote for this query.

(click on this box to dismiss)

StackOverflow has fewer answering users than before. It maxed out around 2014, when exponential growth suddenly halted (either because maximum spread has been reached, or the community was overwhelmed with being able to accomodate low-quality questions and new users).

Stack Overflow

Q&A for professional and enthusiast programmers

--StartTime: Start time of plot - end time always is end of the previous month.
--MinAnswers: Minimum answers per week
DECLARE @StartTime DATETIME = convert(DATETIME, '##StartTime?2000/01/01 00:00:00##')
DECLARE @EndTime DATETIME = dateadd(day,-datepart(weekday,getdate()),getdate())
DECLARE @MinAnswer INT = convert(int, '##MinAnswers?3##')
SET DATEFIRST 1 -- Monday as week start.

select
  WeekOf,
  count(distinct OwnerUserId) as "Answered 3+ Questions a Week"
from (select
  WeekOf,
  OwnerUserId,
  count(*) as "Cnt"
from (select
    OwnerUserId,
    dateadd(day, 1-datepart(weekday, CreationDate), convert(date,CreationDate)) as 'WeekOf'
  from
    Posts q
  where
    q.CreationDate > @StartTime and q.CreationDate < @EndTime
    and q.PostTypeId = 2 -- answers only
    and q.ClosedDate is null -- not closed
) t1
group by
  WeekOf, OwnerUserId
) t2
where
  t2.Cnt >= @MinAnswer
group by
  WeekOf
order by
  WeekOf desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results