Etl, Data Integration, Data Analysis, Data Engineering, Sql.
would you join these two tables in this situation? Imagine, you need to calculate TOTAL CUSTOMER SPEND BY CUSTOMER REGION? Lets calculate TOTAL CUSTOMER SPEND BY REGION by joining both tables only on the CUSTOMER ID column. SELECT c.customer_region, sum(ORDER_AMOUNT) FROM ORDERS O LEFT JOIN