with diffs as (select cast(a.creationdate - q.creationd...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Enter Query Title
-- Enter Query Description


with diffs as
(select cast(a.creationdate - q.creationdate as float) as d from posts q
join posts a on a.id = q.acceptedanswerid)
select avg(d), stdev(d) from diffs

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results