Preguntas y respuestas para programadores y profesionales de la informática
SELECT AVG(DATEDIFF(HOUR, CreationDate, ClosedDate)) AS avg_secs FROM Posts WHERE ClosedDate IS NOT NULL AND datepart(year, CreationDate) = 2017