where not between easy solution
Intuition\nFast and clearly to understanf for beginners\n\n\n# Code\n\nSELECT product_id, product_name\nFROM product\nWHERE product_id IN (\n    SELECT product_
# Intuition\nFast and clearly to understanf for beginners\n\n\n# Code\n```\nSELECT product_id, product_name\nFROM product\nWHERE product_id IN (\n    SELECT product_id\n    FROM sales\n    WHERE sale_date  BETWEEN \'2019-01-01\' AND  \'2019-03-31\'\n) AND product_id NOT IN (\n    SELECT product_id\n    FROM sales\n    WHERE sale_date NOT  BETWEEN \'2019-01-01\' AND  \'2019-03-31\'\n);\n```
['MySQL']