리트코드(LeetCode) SQL 문제풀이 - 607. Sales Person

2023. 1. 26. 17:05코딩테스트/리트코드(LeetCode) - SQL Study Plan

MySQL 문제 607. Sales Person

 

select name from SalesPerson where sales_id NOT IN (
    select sales_id from Orders where com_id IN (
        select com_id from Company where name='RED'))
728x90