#607 Sales Person

SELECT name 
FROM SalesPerson 
WHERE sales_id NOT IN (SELECT sales_id 
                       FROM Orders 
                       WHERE com_id = (SELECT com_id 
                                       FROM Company
                                       WHERE name = 'RED'))

Previous#596 Classes More Than 5 Students Next#620 Not Boring Movies

Last updated 3 years ago

Was this helpful?

SELECT name 
FROM SalesPerson 
WHERE sales_id NOT IN (SELECT sales_id 
                       FROM Orders 
                       WHERE com_id = (SELECT com_id 
                                       FROM Company
                                       WHERE name = 'RED'))

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