Sales Analysis III.sql

SELECT p.product_id,
       p.product_name
  FROM product AS p JOIN sales AS s
    ON p.product_id = s.product_id
 GROUP BY s.product_id
HAVING MIN(s.sale_date) >= '2019-01-01'
   AND MAX(s.sale_date) <= '2019-03-31';