#123. [LeetCode / MySQL] 1327. List the Products Ordered in a Period

문제

 

 

입력 코드

1.

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

 

 

2.

SELECT p.product_name, SUM(o.unit) AS unit
FROM Products AS p
JOIN Orders AS o
USING(product_id)
WHERE MONTH(o.order_date) = 2 AND YEAR(order_date) = 2020
GROUP BY o.product_id
HAVING unit >= 100

 

 

코드 설명

#SELECT #SUM #JOIN #USING #WHERE #BETWEEN #GROUP BY #HAVING #MONTH #YEAR

 

 

문제 출처

https://leetcode.com/problems/list-the-products-ordered-in-a-period/?envType=study-plan-v2&envId=top-sql-50