The analytics team wants a continuous daily chart of order volume from May 21 through May 26, 2026, inclusive.
Use the orders table to count all orders for each date, regardless of status. The chart must show every one of the 6 dates, even on days when no orders were placed. Those days should have an order_count of 0 rather than being absent.
Ordering: Sort by day from earliest to latest. Return exactly 6 rows.