The analytics team wants to track how many orders were placed on each calendar day.
Using orders, prepare a daily summary based on the date of order_ts. Count every order, including refunded, cancelled, delivered, and orders with a missing status. Show only dates on which at least one order exists; dates with no orders do not need a row.
Ordering: Sort by day in ascending order.