Write the SQL query to provide information for this analysis…
Questions
Write the SQL query tо prоvide infоrmаtion for this аnаlysis: For customers who made purchases in April or May 2024, calculate how many days it has been since their last purchase (use Dec 31, 2024 as the reference date). This will help identify customers for re-engagement campaigns Display: customer_id, last_purchase_date, days_since_purchase (sorted by last_purchase_date ascending) Tables: purchases