Regional Sales Performance and Customer Lifetime Value Analysis

Problem Statement

Regional Sales Performance and Customer Lifetime Value Analysis You are given a retail database containing information about customers, products, categories, orders and order items. Write a query that generates a regional sales performance report with customer-lifetime-value tiers, market-penetration figures and profitability figures. Only customers who have made at least one completed order are included, and every order-derived figure is computed from completed orders only ( status = 'completed' ); orders in any other status are ignored entirely. Tables customers Column Type Description customer_id INT Unique id of the customer customer_name VARCHAR Name of the customer (unique within a test) email VARCHAR Email of the customer city VARCHAR City of the customer registration_date DATE Registration date, YYYY-MM-DD categories Column Type Description category_id INT Unique id of the category category_name VARCHAR Name of the category parent_category_id INT Parent category, NULL for a top