607. 销售员

English Version

题目描述

None

解法

SQL

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'))