# Write your MySQL query statement below
select p.product_id, p.product_name
from Product p left join Sales s
on p.product_id = s.product_id
group by p.product_id
having sum(sale_date < '2019-01-01') = 0 and sum(sale_date > '2019-03-31') = 0
《学习SQL语句》——第十四天
于 2023-04-21 12:34:14 首次发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)