[리트코드] List the Products Ordered in a Period - 기본에 충실하자! 조인과 having⚡️

 

# 문제

https://leetcode.com/problems/list-the-products-ordered-in-a-period/description/

 

 

# 문제 요약

 

2월 동안 100개 이상으로 팔린 제품이름과 수량 출력하기

 

 

# 정답 코드

with cte as (
    select p.product_id, p.product_name, p.product_category, o.order_date, o.unit
    from Products p
    inner join Orders o
    on p.product_id = o.product_id
    where o.order_date >= '2020-02-01' and o.order_date < '2020-03-01'
), cte2 as (
    select product_name,
           sum(unit) as unit
    from cte 
    group by product_name
    having sum(unit) >= 100
)
select *
from cte2