Leetcode 607. 销售员（经典嵌套子查询）

代码语言：javascript复制

select name from 
    salesperson s
    where sales_id not in
    (
        select sales_id 
            from orders 
            where com_id=( 
                select com_id from company c 
                where name='RED'
            )
    )

leetcode

0 人点赞