Scenario SQL Question

Find Customers Inactive for 90+ Days

Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.

Problem Statement

Write a query to identify customers who haven't made a purchase in the last 90 days from the most recent order date. Return customer_id, customer_name, last_order_date, days_since_last_order, and customer_status ('At Risk' if 30-90 days, 'Churned' if >90 days).

Relevant Tables

customersorders

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

Date & Time FunctionsSQL Fundamentals
Range & Interval FilteringAdvanced Filtering
NULL HandlingSQL Fundamentals