g0601_0700.s0607_sales_person.script.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of leetcode-in-java Show documentation

Java-based LeetCode algorithm problem solutions, regularly updated

There is a newer version: 1.37

# Write your MySQL query statement below
# #Easy #LeetCode_Curated_SQL_70 #Database #SQL_I_Day_6_Union
# #2022_06_03_Time_1046_ms_(86.04%)_Space_0B_(100.00%)
SELECT NAME 
FROM
SALESPERSON 
WHERE SALES_ID NOT IN 
(
SELECT O.SALES_ID FROM ORDERS AS O LEFT JOIN COMPANY C
ON O.COM_ID = C.COM_ID 
WHERE C.NAME = 'RED'
)