1084.sql (196B)
1 SELECT P.product_id, P.product_name 2 FROM Product P 3 LEFT JOIN Sales S 4 ON P.product_id = S.product_id 5 GROUP BY P.product_id 6 HAVING MIN(sale_date) >= '2019-01-01' AND MAX(sale_date) <= '2019-03-31';