Time to first answer, v1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles

Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT DATEDIFF(MINUTE, q.CreationDate, a.CreationDate),
  COUNT(*) AS 'Number of questions answered within x minutes'
  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(MINUTE, q.CreationDate, a.CreationDate) < 60
  GROUP BY DATEDIFF(MINUTE, q.CreationDate, a.CreationDate)
  ORDER BY DATEDIFF(MINUTE, q.CreationDate, a.CreationDate)

Enter Parameters

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