• Home
• com.github.javadev
• leetcode-in-kotlin
• 1.10
• source code
• script.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

# Write your MySQL query statement below
# #Easy #LeetCode_Curated_SQL_70 #Database #SQL_I_Day_6_Union
# #2023_02_03_Time_2142_ms_(44.56%)_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'
)