Questions that had Answers after Accepting


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 q.Id as [Post Link]
       , q.CreationDate   as 'Question Date'
       , v.CreationDate   as 'Accepted Date'
       , count (a.Id)     as 'Answers After Accepting'
from Posts as q
     left outer join Votes as v on v.PostId = q.AcceptedAnswerId
     join Posts as a on a.ParentId = q.Id
     and (a.CreationDate - v.CreationDate) > 1
where q.PostTypeId = 1 
      and v.VoteTypeId = 1
group by q.Id, q.CreationDate, v.CreationDate

Enter Parameters

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