Problem Statement

For each customer whose most recent order is more than 30 days before the latest order in the dataset, report days_since_last_order and a customer_status of 'Churned' (>90), 'At Risk' (>30), else 'Active'. Return customer_id, customer_name, last_order_date, days_since_last_order, customer_status — ordered by days_since_last_order DESC.

Relevant Tables