Simplest & Fastest, Runtime Beats 100% AC Submissions
SELECT name FROM salesperson WHERE sales_id NOT IN (\n    SELECT sales_id FROM orders JOIN company ON orders.com_id = company.com_id \n        WHERE name = \'RE
SELECT name FROM salesperson WHERE sales_id NOT IN (\n    SELECT sales_id FROM orders JOIN company ON orders.com_id = company.com_id \n        WHERE name = \'RED\'\n);
[]