Distribution of question age when answered

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

SELECT DATEDIFF(day, Question.CreationDate, Answer.CreationDate) as delay, COUNT(*)
  FROM (SELECT TOP 1000 * FROM Posts WHERE PostTypeId = 2) as Answer
  JOIN Posts AS Question
    ON Answer.ParentId = Question.Id
  GROUP BY DATEDIFF(day, Question.CreationDate, Answer.CreationDate) ORDER BY delay

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results