README_EN.md

607. Sales Person

中文文档

Description

None

Solutions

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