leetcode - 1068. Product Sales Analysis I

난이도 : Easy

 

 

고민 과정

1. 두 테이블을 product_id를 활용하여 Join 해주기

2. product_name, year, price, sale_id 추출

 

방법

SELECT product_name
     , year
     , price
FROM Sales
     JOIN Product ON Sales.product_id = Product.product_id

Accepted