0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for anime and manga fans

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
        AND OwnerUserId = ##UserId:int##
        -- merged questions can have older answers
        AND CreationDate >= q.CreationDate
  ) a
  WHERE DATEDIFF(MINUTE, q.CreationDate, a.CreationDate) < 300
  GROUP BY DATEDIFF(MINUTE, q.CreationDate, a.CreationDate)
  ORDER BY DATEDIFF(MINUTE, q.CreationDate, a.CreationDate)

fork query

edited dec 4 20 anonymous

created dec 4 20 Glorfindel