Most intimidating questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  MIN(DATEDIFF(day, Questions.CreationDate, Answers.CreationDate)) as 'Unanswered Time',
  Questions.Id as [Post Link]
FROM
  Posts AS Answers
INNER JOIN
  Posts AS Questions
  ON
    Answers.ParentId = Questions.Id
GROUP BY
  Questions.Id
ORDER BY
  'Unanswered Time' DESC

Enter Parameters

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