Boeing, Recently Asked Online Assessments in 16 Mar, 2026 | Regional Sales Performance | Customer Lifetime Value SQL | SWE Coding Assessment | Complete Solutions & Tips

Question: Regional Sales Performance and Customer Lifetime Value Analysis Difficulty: Medium Problem Statement: You are given a retail database containing information about customers, products, categories, orders, and order items. Task: Write a query that generates an advanced regional sales performance analysis with customer lifetime value metrics, market penetration insights, and profitability patterns. Only include customers who have made at least one completed order and display all monetary values with exactly 2 decimal places, sorted by total region revenue (highest first), ...