Scenario A: Messy Retail Sales ExtractYou are analyzing a re…

Scenario A: Messy Retail Sales ExtractYou are analyzing a retail dataset with columns: date (string like “2025-03-01”) region (text with inconsistent capitalization and extra spaces) channel (“Online” or “Store”) price (numeric, may contain missing values) quantity (integer) Assume each row is an order line. You will clean the data and compute KPIs.You want total revenue by region. Which expression is best?