Etl, Data Integration, Data Analysis, Data Engineering, Sql.
CUSTOMERS C ON O.CUSTOMER_ID = C.CUSTOMER_ID GROUP BY c.customer_region Using above script to calculate total spend by each customer would be wrong. RESULT BELOW: Above answer would be totally wrong because we know the total spend by our only two AFRICAN customers was 2,270. Calculated using query