#1084 Sales Analysis III

SELECT product_id, product_name
FROM Product
WHERE product_id NOT IN(
    SELECT product_id 
    FROM Sales
    WHERE sale_date < '2019-01-01' OR sale_date > '2019-03-31')

Previous#1050 Actors and Directors Who Cooperated At Least Three Times Next#1141 User Activity for the Past 30 Days I

Last updated 3 years ago

Was this helpful?

SELECT product_id, product_name
FROM Product
WHERE product_id NOT IN(
    SELECT product_id 
    FROM Sales
    WHERE sale_date < '2019-01-01' OR sale_date > '2019-03-31')

https://leetcode.com/problems/sales-analysis-iii/