How long between a question is asked, and the answer arrives....
Q&A for those who study, teach, research and apply economics and econometrics
-- measure from the answer time, not the question time. -- this implies certain things, more to follow. declare @history as int = - ##Weeks:int?60## declare @zombie as int = ##Zombie:int?30## ; with QandA as ( select p.Id, p.CreationDate as QDate, min(a.CreationDate) as ADate from Posts p, Posts a where p.Id = a.ParentId and p.PostTypeId = 1 and a.PostTypeId = 2 and a.ClosedDate is null and p.closedDate is null and a.CreationDate >= convert(Date, DateAdd(week, @history, CURRENT_TIMESTAMP)) group by p.Id, p.CreationDate ), AnswerDelays as ( select DATEADD(DAY, 7 - DATEPART(WEEKDAY, CONVERT(DATE,ADate)), CONVERT(DATE,ADate)) as WeekEnd, convert (Decimal(8,2), DateDiff(minute, QDate, ADate) / Convert(float, 60)) as Delay from QandA ) select WeekEnd as WeekEnd, Avg(Delay) as AnswerDelay, Stdev(Delay) as StdDev from AnswerDelays where Delay < (@zombie * 1440) and WeekEnd < CURRENT_TIMESTAMP group by WeekEnd --select count (*) from QandA