SUM(CASE WHEN region = 'North' THEN revenue ELSE 0 END) AS north_sales, SUM(CASE WHEN region = 'South' THEN revenue ELSE 0 END) AS south_sales, SUM(CASE WHEN region ...