Time to first answer, v2

0

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

SELECT DATEDIFF(HOUR, q.CreationDate, a.CreationDate),
  COUNT(*) AS 'Number of questions answered within x hours'
  FROM Posts AS q
  CROSS APPLY (
    SELECT MIN(CreationDate) AS CreationDate
      FROM Posts
      WHERE ParentId = q.Id
        -- merged questions can have older answers
        AND CreationDate >= q.CreationDate
  ) a
  WHERE DATEDIFF(HOUR, q.CreationDate, a.CreationDate) < 48
  GROUP BY DATEDIFF(HOUR, q.CreationDate, a.CreationDate)
  ORDER BY DATEDIFF(HOUR, q.CreationDate, a.CreationDate)

Enter Parameters

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