Identify Products Sold Exclusively in January 2024
Using the tables playground.products and playground.product_sales, write a SQL query to find products that were sold exclusively within the month of January 2024 (from "2024-01-01" to "2024-01-31", inclusive). The output should include the product_id and product_name for each qualifying product.
These are the tables to query for this question:
playground.products- product_id int
- product_name string
- unit_price int
- seller_id int
- product_id int
- buyer_id int
- sale_date date
- quantity int
- price int
Your answer should include these columns:
- product_id integer
- product_name varchar
Querying is only for logged in users!
Sign In