LeetCode / 1084. Sales Analysis III / MySQL / Easy
2023. 12. 28. 18:50
📚문제 📝풀이 # Write your MySQL query statement below SELECT DISTINCT s.product_id , p.product_name FROM Sales s INNER JOIN Product p ON s.product_id = p.product_id WHERE s.sale_date BETWEEN '2019-01-01' AND '2019-03-31' AND s.product_id NOT IN (SELECT DISTINCT product_id FROM Sales WHERE sale_date NOT BETWEEN '2019-01-01' AND '2019-03-31') 처음에는 WHERE절 서브쿼리에서 계속 오답이 발생해서 WHERE sale_date > '2019-03-31..
