No sub query with GROUP BY and HAVING
SELECT s.name FROM salesperson s\nLEFT JOIN orders o \nUSING (sales_id)\nLEFT JOIN company c\nUSING (com_id)\nGROUP BY sales_id\nHAVING SUM(CASE c.name WHEN \'R
SELECT s.name FROM salesperson s\nLEFT JOIN orders o \nUSING (sales_id)\nLEFT JOIN company c\nUSING (com_id)\nGROUP BY sales_id\nHAVING SUM(CASE c.name WHEN \'RED\' THEN 1 ELSE 0 END)=0
[]