The retention team wants to identify customers who made purc…
The retention team wants to identify customers who made purchases in Q3 2024 (July, August, or September 2024) to analyze late-summer buying behavior. For each qualifying purchase, calculate how many days have passed since that purchase using December 31, 2024 as the reference date. Display:customer_name, product_name, purchase_date, purchase_month, days_since_purchase Sorted by days_since_purchase ascending. Table: purchases, customers, products