[MySQL] || SubQuery || LEFT JOIN
Write your MySQL query statement below\n\n\nWITH cte AS\n(SELECT product_id FROM Sales\nWHERE sale_date > \'2019-03-31\'\nOR sale_date < \'2019-01-01\')\n\nSELE
# Write your MySQL query statement below\n```\n\nWITH cte AS\n(SELECT product_id FROM Sales\nWHERE sale_date > \'2019-03-31\'\nOR sale_date < \'2019-01-01\')\n\nSELECT DISTINCT s.product_id , p.product_name\nFROM Sales s\nLEFT JOIN Product p\nON s.product_id=p.product_id  \nWHERE s.product_id NOT \nIN(SELECT product_id FROM cte); \n```\n
['MySQL']