Easy solution. No subquery, Inner join, right join
"""\nselect s.name from orders o\njoin Company c on o.com_id = c.com_id and c.name = \'RED\'\nright join SalesPerson s on o.sales_id = s.sales_id \nwhere o.sale
"""\nselect **s.name** from orders o\njoin Company c on **o.com_id = c.com_id and c.name = \'RED\'**\n**right join** SalesPerson s on **o.sales_id = s.sales_id** \nwhere **o.sales_id is null**\n"""
[]