2893. Calculate Orders Within Each Interval

SQL

SELECT
  CEIL(minute / 6) AS interval_no,
  SUM(order_count) AS total_orders
FROM Orders
GROUP BY 1
ORDER BY 1;