1084. Sales Analysis III mysql

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

Sales Analysis III - LeetCode

틀린 시도

select p.product_id, p.product_name
from (select product_id, sale_date from sales where sale_date between '2019-01-01' and '2019-03-31') tb join product p on p.product_id = tb.product_id
where p.product_id not in (select product_id from sales where sale_date not between '2019-01-01' and '2019-03-31');

 

비효율적이고 4/13에서 wrong answer이 나왔음

 

SELECT p.product_id, p.product_name
FROM Product p, Sales s
WHERE p.product_id = s.product_id
GROUP BY s.product_id
HAVING MIN(s.sale_date) >= '2019-01-01' AND MAX(s.sale_date) <= '2019-03-31';

참고 :  https://hkim-data.tistory.com/276

[LeetCode] Sales Analysis III (최소 최대 GROUP BY MINMAX 활용)

 

테이블 두 개를 이전까지는 subquery로 만들어서 join했는데 where 절을 활용해서 깔끔하게도 풀 수 있었다. 

앞으로의 SQL 문제들은 저렇게 풀어야겠다. ㅎㅎ