leetcode - 1069. Product Sales Analysis II

난이도 : Easy

 

 

고민 과정

1. 테이블이 2개이지만, Join할 필요 없다.

2. product_id를 활용하여 group by

3. sum(quantity) 추출

 

방법

SELECT product_id
     , SUM(quantity) total_quantity 
FROM Sales
GROUP BY product_id

Accepted