# Sales Person LeetCode Solution

This Leetcode problem Sales Person LeetCode Solution is done in SQL.

# List of all LeetCode Solution

## Problem Statement

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.

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.

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.

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.

Example 1:
Input:

Output:

Explanation: According to orders 3 and 4 in the Orders table, it is easy to tell that only salespersons John and Pam have sales to company RED, so we report all the other names in the table salespersons.

## Sales Person LeetCode Solution MySQL

``````select
s.name
from
salesperson as s
where
s.sales_id not in(
select
sales_id
from
orders as o
left join company as c on o.com_id = c.com_id
where
c.name = 'RED'
);```Code language: SQL (Structured Query Language) (sql)```
Scroll to Top