607. Sales Person

내공얌냠 2022. 6. 3. 13:47

https://leetcode.com/problems/sales-person/

Sales Person - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

믿기진 않지만 best와 동일

select name
from SalesPerson
where sales_id not in (select distinct sales_id from Orders where com_id = (select com_id from Company where name = 'RED'))

728x90