E-Commerce Customer Lifetime Value & RFM Segmentation

• Domain: Retail / E-Commerce

• Business Question: "Who are our most valuable customers, and how can marketing target them to reduce churn and maximize retention?"

• SQL Concepts Demonstrated: CTEs (WITH), Aggregate Functions (SUM, AVG, COUNT), NTILE() Window Functions for scoring, and CASE WHEN conditional statements.