select q.Id as [Post Link] , q.CreationDate as 'Questio...

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 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
where q.PostTypeId = 1 
      and v.VoteTypeId = 1
group by q.Id, q.CreationDate, v.CreationDate

Enter Parameters

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