Leetcode Problem 607. Sales Person

607. Sales Person

Leetcode Solutions

Excluding Salespersons with Orders from Company 'RED'

Join the Orders table with the Company table on the com_id column.
Filter the joined table to only include orders where the company name is 'RED'.
Select the sales_id from the filtered results to identify salespersons who have made sales to 'RED'.
Use the NOT IN clause with a subquery to select all salespersons from the SalesPerson table whose sales_id is not in the list of salespersons who made sales to 'RED'.
Return the name column of the resulting salespersons.

erDiagram
    SalesPerson ||--o{ Orders : ""
    Company ||--o{ Orders : ""
    SalesPerson {
        int sales_id PK
        varchar name
        int salary
        int commission_rate
        date hire_date
    }
    Company {
        int com_id PK
        varchar name
        varchar city
    }
    Orders {
        int order_id PK
        date order_date
        int com_id FK
        int sales_id FK
        int amount
    }

Using LEFT JOIN and IS NULL to Exclude Salespersons with Orders from Company 'RED'

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Leetcode Problem 607. Sales Person

Leetcode Solutions

Excluding Salespersons with Orders from Company 'RED'

Solution Idea

Query Steps

Code Implementation

Using LEFT JOIN and IS NULL to Exclude Salespersons with Orders from Company 'RED'

Ask Question

Suggested Answer