Distribution of question age when answered


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 CONVERT(INT, Answer.CreationDate - Question.CreationDate) as delay
  INTO #delays
  FROM (SELECT TOP 1000000 * FROM Posts WHERE PostTypeId = 2) as Answer
  JOIN Posts AS Question
    ON Answer.ParentId = Question.Id;
SELECT count(*) FROM #delays WHERE delay >= 0 AND delay < 100 GROUP BY delay ORDER BY delay ASC;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results