leetcode 1084 销售分析III
leetcode 1084 销售分析III
select distinct p.product_id, p.product_name from Product p left join Sales s on p.product_id = s.product_id where s.product_id not in ( select product_id from Sales where sale_date < '2019-01-01' or sale_date > '2019-03-31' )
select product_id, product_name from product p where p.product_id in ( select s.product_id from sales s group by s.product_id having max(s.sale_date) <= date('2019-03-31') and min(s.sale_date) >= date('2019-01-01') )
==