leet_sql_8_1084. Sales Analysis III

# Write your MySQL query statement below
select distinct(s.product_id),p.product_name
from sales s
left join product p on p.product_id=s.product_id
where s.sale_date between   '2019-01-01' and '2019-03-31'  AND p.product_id NOT IN (
    SELECT s.product_id
    FROM Sales s
    WHERE s.sale_date < '2019-01-01' or s.sale_date > '2019-03-31'
  );