리트코드(LeetCode) SQL 문제풀이 - 1084. Sales Analysis III

 

MySQL 문제 1084. Sales Analysis III

 

MySQL 답

select s.product_id,p.product_name
    from Sales s
    join Product p ON p.product_id=s.product_id
    group by s.product_id
    having MIN(DATE_FORMAT(s.sale_date,'%Y-%m-%d'))>='2019-01-01' AND 
           MAX(DATE_FORMAT(s.sale_date,'%Y-%m-%d'))<='2019-03-31';