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(Minute, qu.CreationDate, ans.CreationDate) AS Minutes
from posts qu
join posts ans on qu.AcceptedAnswerId = ans.Id
GROUP BY datediff(Minute, qu.CreationDate, ans.CreationDate), qu.Title
order by datediff(Minute, qu.CreationDate, ans.CreationDate)

fork query

edited apr 22 14

created apr 22 14 anonymous