LeetCode刷题---销售分析III

首先找出在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