0607.sql (163B)
1 SELECT P.name 2 FROM Orders O 3 JOIN Company C 4 ON O.com_id = C.com_id AND C.name = 'RED' 5 RIGHT JOIN SalesPerson P 6 ON P.sales_id = O.sales_id 7 WHERE O.sales_id IS NULL 8