Distribution of question age when answered

0

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

SELECT DATEDIFF(day, Question.CreationDate, Answer.CreationDate) as delay
  INTO #delays
  FROM (SELECT TOP 100000 * FROM Posts WHERE PostTypeId = 2) as Answer
  JOIN Posts AS Question
    ON Answer.ParentId = Question.Id;
    
SELECT delay, count(*) FROM #delays WHERE delay >= 0 AND delay < 100 GROUP BY delay ORDER BY delay ASC;

Enter Parameters

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