首先找出在sales表中筛选出符合指定日期的prioduct_id,将其查询结果命名为t1
select
product_id
from sales
group by product_id
having max(sale_date)<='2019-03-31' and min(sale_date)>='2019-01-01'
与product表进行关联得出最终结果
select
product.product_id as product_id,product.product_name
from
product,t1
where product.product_id=t1.product_id