1084. Sales Analysis III.sql

/*
Question 1084. Sales Analysis III
Link: https://leetcode.com/problems/sales-analysis-iii/description/?envType=problem-list-v2&envId=database

Table: Product

+--------------+---------+
| Column Name  | Type    |
+--------------+---------+
| product_id   | int     |
| product_name | varchar |
| unit_price   | int     |
+--------------+---------+
product_id is the primary key (column with unique values) of this table.
Each row of this table indicates the name and the price of each product.
Table: Sales

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| seller_id   | int     |
| product_id  | int     |
| buyer_id    | int     |
| sale_date   | date    |
| quantity    | int     |
| price       | int     |
+-------------+---------+
This table can have duplicate rows.
product_id is a foreign key (reference column) to the Product table.
Each row of this table contains some information about one sale.
 

Write a solution to report 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.
*/

WITH sales_other_q AS (
    SELECT DISTINCT product_id
    FROM Sales
    WHERE sale_date NOT BETWEEN '2019-01-01' AND '2019-03-31'
) 

SELECT DISTINCT
    s.product_id,
    p.product_name
FROM Sales AS s
LEFT JOIN 
    sales_other_q AS q
    ON s.product_id = q.product_id
LEFT JOIN 
    Product AS p
    ON s.product_id = p.product_id
WHERE q.product_id IS NULL