Q&A about the site for Ubuntu users and developers
-- *BONUS* For the questions created in 2017, what was the average time (in seconds) between when the question was created and when the accepted answer was provided?
;with questions_answered as (
year(creationdate) = 2017
and Acceptedanswerid is not null
qa.CreationDate as 'Question_date',
p.Creationdate as 'Answer_date'
questions_answered qa on qa.AcceptedAnswerid = p.id