[LeetCode] 1084. Sales Analysis III

 

 

[문제]

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

 

 

[MySQL]

SELECT p.product_id
     , p.product_name
FROM Product AS p
    LEFT JOIN Sales AS 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'