EASY MySQL Solution || LEFT JOIN || INNER JOINS
\n# Write your MySQL query statement below\nWITH rejected_ids AS (\n    SELECT s.product_id\n    FROM sales s\n    WHERE s.sale_date NOT BETWEEN DATE(\'2019-01-
```\n# Write your MySQL query statement below\nWITH rejected_ids AS (\n    SELECT s.product_id\n    FROM sales s\n    WHERE s.sale_date NOT BETWEEN DATE(\'2019-01-01\') AND DATE(\'2019-03-31\')\n)\nSELECT DISTINCT p.product_id, p.product_name\nFROM product p\nINNER JOIN sales s ON s.product_id = p.product_id\nLEFT JOIN rejected_ids r ON r.product_id = p.product_id\nWHERE s.sale_date BETWEEN DATE(\'2019-01-01\') AND DATE(\'2019-03-31\') AND r.product_id IS NULL\n```
['MySQL']