Q&A for Ubuntu users and developers
SELECT TOP 10 DATEDIFF(HOUR, CreationDate, ClosedDate), CreationDate, ClosedDate FROM Posts WHERE ClosedDate IS NOT NULL AND datepart(year, CreationDate) = 2017