0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

-- Response time: distribution in hours until accepted answer

select COUNT(*) AS [Count], 
      datediff(Hour, qu.CreationDate, ans.CreationDate) AS Hours
from posts qu
join posts ans on qu.AcceptedAnswerId = ans.Id
GROUP BY datediff(Hour, qu.CreationDate, ans.CreationDate)
order by [Hours] ASC

fork query

edited nov 21 12 anonymous

created jul 9 11 Jan Fabry