리트코드 [Sales Analysis III]

문제

https://leetcode.com/problems/sales-analysis-iii/description/

2019년 1분기에만 판매된 제품조건을 추출하자.
(product_id, product_name 출력)

Table : Product

Table : Sales

Example1

쿼리

SELECT p.product_id, p.product_name
FROM Product p 
join Sales s on p.product_id = s.product_id
group by p.product_id
HAVING MIN(s.sale_date) >= '2019-01-01' AND MAX(s.sale_date) <= '2019-03-31';