Q&A about the site for movie and tv enthusiasts
-- *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.id = p.AcceptedAnswerid