Most difficult 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',
  Answers.CreationDate as 'Answer Date',
  DATEDIFF(day, Questions.CreationDate, Answers.CreationDate) as 'Unsolved Time',
  Questions.Id as [Post Link],
  Answers.Id as [Post Link]
FROM
  Votes
INNER JOIN
  Posts AS Answers
  ON
    Votes.PostId = Answers.Id
INNER JOIN
  Posts AS Questions
  ON
    Answers.ParentId = Questions.Id
WHERE
  Votes.VoteTypeId = 1
ORDER BY
  'Unsolved Time' DESC

Enter Parameters

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