LeetCode Sales Personを解いてみた

問題

leetcode.com

解いた

サブクエリで該当のsales_idを引っ張ってくるだけ。

SELECT
    name
FROM
    SalesPerson
WHERE
    sales_id NOT IN(
        SELECT
            sales_id AS id FROM Orders
        LEFT OUTER JOIN Company ON Orders.com_id = Company.com_id
WHERE
    Company.name = 'RED');

結果