how long did it take to accept answer

0

Please login or register to vote for this query.

(click on this box to dismiss)

Accepted answers with negative scores and more than 1000 views

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
  question.id as [Post Link], 
  answer.CreationDate, v.*,
  datediff(hour, v.CreationDate, answer.CreationDate) as dif
FROM 
  Posts question JOIN Posts answer ON question.AcceptedAnswerId = answer.Id
  JOIN Votes v ON v.PostId = answer.Id
WHERE
  answer.OwnerUserId=112052 AND v.VoteTypeId = 1
ORDER BY datediff(hour, v.CreationDate, answer.CreationDate) DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results