Etl, Data Integration, Data Analysis, Data Engineering, Sql.
fields/columns as seen below. CUSTOMER ID is duplicated hereby we join on both CUSTOMER ID and CUSTOMER NAME. SCRIPT BELOW: SELECT c.customer_region, sum(ORDER_AMOUNT) AS TOTAL_SPEND_BY_REGION FROM ORDERS O LEFT JOIN CUSTOMERS C ON O.CUSTOMER_ID = C.CUSTOMER_ID <--- AND O.CUSTOMER_NAME =