Problem: 1084. 销售分析III

👨‍🏫 参考题解

Code

select s.product_id,p.product_name
from sales s left join product p
on s.product_id = p.product_id
group by product_id
having count(if(sale_date between '2019-01-01' and '2019-03-31',1,null)) = count(*)