Skip to content

2893. Calculate Orders Within Each Interval 👍

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