1607. Sellers With No Sales
Problem Statement
Find all the seller names who did not make any sales in 2020. Return the result table ordered by seller_name ascending.
Table Schema
Table: Seller
+-------------+---------+
| seller_id | int |
| seller_name | varchar |
+-------------+---------+
seller_id is the primary key.
Table: Customer
+---------------+---------+
| customer_id | int |
| customer_name | varchar |
+---------------+---------+
customer_id is the primary key.
Table: Orders
+---------------+------+
| order_id | int |
| sale_date | date |
| order_cost | int |
| customer_id | int |
| seller_id | int |
+---------------+------+
order_id is the primary key.
Examples
Example 1
Input Table:
Seller table:
+-----------+-------------+
| seller_id | seller_name |
+-----------+-------------+
| 1 | Daniel |
| 2 | Elizabeth |
+-----------+-------------+
Orders table:
+----------+------------+------------+-------------+-----------+
| order_id | sale_date | order_cost | customer_id | seller_id |
+----------+------------+------------+-------------+-----------+
| 1 | 2019-01-21 | 2500 | 1 | 1 |
+----------+------------+------------+-------------+-----------+
Expected Output:
+-------------+
| seller_name |
+-------------+
| Daniel |
| Elizabeth |
+-------------+
Explanation: Both had no sales in 2020 specifically.
SQL Solution
SELECT seller_name
FROM Seller
WHERE seller_id NOT IN (
SELECT seller_id FROM Orders WHERE YEAR(sale_date) = 2020
)
ORDER BY seller_name ASC;