607. Sales Person leetcode solution

# Write your MySQL query statement belowselect name from SalesPerson where sales_idnot in (    select sales_id from Orders where    com_id = (select com_id from Company     where name="RED"));