MySQL - Beats 94.5%
select \nsp.name\nfrom SalesPerson sp\nLEFT JOIN\n(select order_id, sales_id from Orders o \nLEFT JOIN\nCompany c on o.com_id = c.com_id\nwhere c.name = \'RED\'
select \nsp.name\nfrom SalesPerson sp\nLEFT JOIN\n(select order_id, sales_id from Orders o \nLEFT JOIN\nCompany c on o.com_id = c.com_id\nwhere c.name = \'RED\'\n )o on sp.sales_id = o.sales_id\nwhere o.order_id is null\ngroup by 1
[]