The analytics team wants to track daily order volume and the number of different customers placing orders.
Using the orders table, prepare a daily summary showing the total orders and unique customers for each order_date.
All orders count regardless of status, including guest checkouts without a customer_id. However, guest checkouts should not increase the unique customer count, and customers placing multiple orders should be counted only once as customers.
Ordering: Sort by day in ascending order.