Easy to understand mySQL solution using a subquery
\nSELECT product_id, product_name FROM product\n\nWHERE product_id IN \n\n\t(SELECT DISTINCT product_id FROM sales\n\n     GROUP BY product_id \n\n     HAVING M
```\nSELECT product_id, product_name FROM product\n\nWHERE product_id IN \n\n\t(SELECT DISTINCT product_id FROM sales\n\n     GROUP BY product_id \n\n     HAVING MIN(sale_date)>= \'2019-01-01\' \n            AND  MAX(sale_date) <= \'2019-03-31\')\n```
['MySQL']