The customer success team wants to see each customer's paid-order activity, including customers who have never placed an order or whose orders were never paid.
The customers table contains the complete customer list, while orders records order statuses and timestamps (order_ts).
Prepare a customer-level report containing the date of each customer's most recent paid order and the number of paid orders they have placed. Only orders with the exact status paid qualify; delivered, refunded, cancelled, and missing statuses do not.
Customers without paid orders must still appear, with NULL for the last paid-order date and 0 for the count.
Ordering: Sort by customer_id in ascending order.