[Solved] SQL find Peak Hour and Peak off Hour from the table

A simple aggregate query something like this will work

SELECT COUNT(*) inserts, DATEPART(HOUR,orderreceivedTime) hour
  FROM order
 GROUP BY DATEPART(HOUR,orderreceivedTime)