1.
SELECT
ORDER_ID,
ORDER_NAME,
SUM(AMOUNT) AS TOTAL_ORDER
FROM ORDER O
JOIN ORDER_ITEM OI ON O.ORDER_ID = OI.ORDER_ID
GROUP BY 1,2
2.
filtered_df = df[df['region'].isin(['East', 'West'])]
result = (filtered_df.groupby('rep', as_index=False)['sales'].sum().rename(columns={'sales': 'total_sales'}:emoji_nose: