Remix of Longest time when an accepted answer is posted but only 10 answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results