Time to first answer, v1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cryptography

Q&A for software developers, mathematicians and others interested in cryptography

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