SELECT Year, Month, Day, Hour, COUNT(Hour) AS “Items per Hour”
FROM
(
SELECT DATEPART(YEAR,DateChecked) Year, DATEPART(MONTH,DateChecked) Month,
DATEPART(DAY,DateChecked) Day, DATEPART(HOUR, DateChecked) Hour
FROM ATABLE
) temp
group by Year, Month, Day, Hour
order by Year desc, Month desc, Day desc, Hour desc