One normal accepted solution


  • 0
    W
    
    SELECT salesperson.name
    FROM salesperson
    WHERE salesperson.sales_id NOT IN (
    SELECT orders.sales_id
    FROM orders
    WHERE orders.com_id = (SELECT com_id FROM company WHERE company.name = 'RED'))
    
    

Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.