You need to write a SQL query that identifies customers whose purchasing behavior changed significantly in the last quarter compared to their historical pattern. How would you approach this?

Sample answer preview

Detecting significant behavioral changes requires establishing a baseline for each customer and then comparing recent behavior against it. This is a powerful application of advanced SQL for proactive business intelligence. Define what constitutes purchasing behavior.