[LeetCode] 1327. List the Products Ordered in a Period

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT p.product_name
     , SUM(o.unit) AS unit
FROM Products AS p
    LEFT JOIN Orders AS o ON p.product_id = o.product_id
WHERE o.order_date >= '2020-02-01'
  AND o.order_date < '2020-03-01'
GROUP BY p.product_id
HAVING SUM(o.unit) >= 100