-- Longest time when an accepted answer is posted
-- Number of days between the question is asked and the accepted answer is posted.
select top 10 cast(a.creationdate - q.creationdate as float) as Days, q.id as [Post Link] from posts q
join posts a on a.id = q.acceptedanswerid
order by Days desc