mysql +having
```\nSELECT \n        p.product_id, p.product_name\nFROM \n        product p\nJOIN \n        Sales s\nON \n        p.product_id = s.product_id \n\nGROUP BY s.pr
```\nSELECT \n        p.product_id, p.product_name\nFROM \n        product p\nJOIN \n        Sales s\nON \n        p.product_id = s.product_id \n\nGROUP BY s.product_id\n        \n      HAVING  max(s.sale_date)<= \'2019-03-31\'\n      AND MIN(s.sale_date)>=\'2019-01-01\';
['MySQL']