[Leetcode] Product Sales Analysis I
정답
SELECT p.product_name, s.year, s.price
FROM Sales s
JOIN Product p
ON s.product_id = p.product_id;
✅ Point
- Order Of Execution
FROM Sales s
>JOIN Product ON ~
>SELECT ~
SELECT p.product_name, s.year, s.price
FROM Sales s
JOIN Product p
ON s.product_id = p.product_id;
FROM Sales s
> JOIN Product ON ~
> SELECT ~