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 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

fork query

edited apr 22 14

created apr 22 14 anonymous