Sales Person - LeetCode

Sales Person 문제

출처 : LeetCode Sales Person

Table : SalesPerson

Colume Name	Type
sales_id	int
name	varchar
salary	int
commission_rate	int
hire_date	date

sales_id is the primary key (column with unique values) for this table.
Each row of this table indicates the name and the ID of a salesperson alongside their salary, commission rate, and hire date.

Table : Company

Colume Name	Type
com_id	int
name	varchar
city	varchar

com_id is the primary key (column with unique values) for this table.
Each row of this table indicates the name and the ID of a company and the city in which the company is located.

Table : Orders

Colume Name	Type
order_id	int
order_date	date
com_id	int
sales_id	int
amount	int

order_id is the primary key (column with unique values) for this table.
com_id is a foreign key (reference column) to com_id from the Company table.
sales_id is a foreign key (reference column) to sales_id from the SalesPerson table.
Each row of this table contains information about one order. This includes the ID of the company, the ID of the salesperson, the date of the order, and the amount paid.

Q.

Write a solution to find the names of all the salespersons who did not have any orders related to the company with the name "RED".
Return the result table in any order.
The result format is in the following example.

---

질문

회사 이름이 RED인 회사와 단 한 번도 거래하지 않은 영업사원(SalesPerson)의 이름을 구하라!

내 답안 📕

SELECT name
FROM SalesPerson
WHERE sales_id NOT IN (SELECT O.sales_id
                       FROM Company AS C
                         INNER JOIN Orders AS O ON C.com_id = O.com_id
                       WHERE C.name = 'RED')