Sales Analysis III || Leetcode SQL solution || Easy approach || sub-query || 🔥🔥🔥🔥💯💯💯💯✅✅✅✅

 

                                        1084. Sales Analysis III

Leetcode question : 1084. Sales Analysis III

Write an SQL query that reports the products that were only sold in the first quarter of 2019. That is, between 2019-01-01 and 2019-03-31 inclusive.

Return the result table in any order.

The query result format is in the following example.

SQL SOLUTION :

select product_id,product_name 
from Product

where product_id not in 
(
    select p.product_id from Product p left join Sales s 
    on p.product_id=s.product_id 
    where s.sale_date <date('2019-01-01') 
    or
    s.sale_date >date('2019-03-31') 
    or
    s.seller_id is null 
);