607. Sales Person leetcode solution

realNameHidden - Apr 22 '23 - - Dev Community

for explanation watch video

# Write your MySQL query statement below
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")
);
Enter fullscreen mode Exit fullscreen mode
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .