faster than 81% of MySQL online submissions
UPVOTE\t\t\t\n\t\t\t\n\t\t\tselect s.name from orders o\n\t\t\tjoin Company c on o.com_id = c.com_id and c.name = \'RED\'\n\t\t\tright join SalesPerson s on o.s
**UPVOTE**\t\t\t\n\t\t\t\n\t\t\tselect s.name from orders o\n\t\t\tjoin Company c on o.com_id = c.com_id and c.name = \'RED\'\n\t\t\tright join SalesPerson s on o.sales_id = s.sales_id\n\t\t\twhere o.sales_id is null
['MySQL']