MYSQL || MIN-MAX || HAVING
\n\n# Code\n\n# Write your MySQL query statement below\nSELECT p.product_id,p.product_name\nFROM Product p\nLEFT JOIN Sales s\nON p.product_id=s.product_id\nGRO
\n\n# Code\n```\n# Write your MySQL query statement below\nSELECT p.product_id,p.product_name\nFROM Product p\nLEFT JOIN Sales s\nON p.product_id=s.product_id\nGROUP BY s.product_id\nHAVING MIN(s.sale_date)>\'2018-12-31\' AND MAX(s.sale_date)<\'2019-04-01\'\n```
['MySQL']