[코드카타] SQL 22 Product Sales Analysis I

[코드카타] SQL 22 Product Sales Analysis I

22. Product Sales Analysis I
https://leetcode.com/problems/product-sales-analysis-i/

Write a solution to report the product_name, year, 
and price for each sale_id in the Sales table.
Return the resulting table in any order.

select p.product_name, year, s.price
from sales s
join product p on s.product_id=p.product_id

#join 후 각 테이블에서 col 추출