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