Oldest unsolved 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
  Questions.CreationDate as 'Ask Date',
  DATEDIFF(day, Questions.CreationDate, GETDATE()) as 'Unsolved Time',
  Questions.Id as [Post Link]
FROM
  Posts AS Questions
WHERE
  Questions.PostTypeId = 1 AND
  Questions.AcceptedAnswerId IS NULL
ORDER BY
  'Unsolved Time' DESC

Enter Parameters

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