Using Having, no sub query needed
SELECT s.product_id, p.product_name\nFROM Sales s JOIN Product p\nON p.product_id = s.product_id\nGROUP BY s.product_id\nHAVING MIN(s.sale_date) >= \'2019-01-01
SELECT s.product_id, p.product_name\nFROM Sales s JOIN Product p\nON p.product_id = s.product_id\nGROUP BY s.product_id\nHAVING MIN(s.sale_date) >= \'2019-01-01\' AND MAX(s.sale_date) <=\'2019-03-31 \'\n
[]