Skip to main content
All Problems
hard0% acceptance

Customer Churn Risk Scoring

Build a churn risk report. For each customer, compute: days since last order (from '2025-01-01'), total orders, average order value, and days between their first and last order. Assign risk: 'High' if no order in 90+ days, 'Medium' if 60-89 days, 'Low' otherwise. Show customer_id, first_name, last_name, total_orders, avg_order_value (rounded to 2), days_since_last_order, and risk_level. Sort by days_since_last_order descending.

Schema

🔑idINT
first_nameTEXT
last_nameTEXT
emailTEXT
phoneTEXTNULL
cityTEXT
stateTEXT
countryTEXT
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute