1084. Sales Analysis III

1084. Sales Analysis III

My solution using left join

select a.product_id, a.product_name
from Product a
left join Sales b
on a.product_id = b.product_id
group by a.product_id
having sum(b.sale_date between '2019-01-01' and '2019-03-31') = count(b.sale_date)

Comments (0)