The analytics team wants a daily activity grid that shows both active and inactive customers.
Using customers and orders, prepare a report for customers c_001, c_002, and c_003 covering May 10, May 11, and May 12, 2026. The report must contain one row for every customer–date combination, whether or not the customer ordered that day.
For each combination, show the number of orders placed on that date. All order statuses count. Report 0 when a customer has no orders on a particular day, including customers who have never ordered.
Ordering: Sort by customer_id, then by day, both in ascending order. Return 9 rows.