# Write your MySQL query statement below
select s.product_id,p.product_name
from Product as p left join Sales as s
on p.product_id = s.product_id
group by s.product_id
having MIN(sale_date) >= '2019-01-01' AND MAX(sale_date) <= '2019-03-31';
注意sql语句顺序
为什么不用 between and 因为这个语句是where语句,只能再分组之前用。但是这个题目要在分组后再进行筛选,所以只能在分组后用Having语句了