0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

select COUNT(*) AS [Count], qu.Title,
      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), qu.Title
order by [Count] ASC

fork query

created apr 22 14 anonymous