Q&A for pro webmasters
select Answer_time = t1.ClosedDate - t1.CreationDate from Posts t1 where t1.CreationDate between '2017-01-01' and '2017-12-31';