Regional Sales Performance and Customer Lifetime Value Analysis

Problem Statement

Problem Description You are analyzing a retail database to generate an advanced regional sales performance report along with customer lifetime value metrics, market penetration insights, and profitability patterns. Write a SQL query that computes these metrics for customers who have made at least one completed order ( status = 'completed' ). All metrics involving orders (e.g., spending, order counts, categories, dates) must only consider completed orders. Schema Table: customers Column Type Description customer_id INT Unique customer identifier customer_name VARCHAR Customer's full name email VARCHAR Customer's email address city VARCHAR Customer's city registration_date DATE Date the customer registered Table: categories Column Type Description category_id INT Unique category identifier category_name VARCHAR Name of the category parent_category_id INT ID of the parent category (if any) Table: products Column Type Description product_id INT Unique product identifier product_name VARCHA