NESTED QUERY | SQL | EASY
SALES PERSON PROBLEM \n\n\nSELECT name\nFROM SalesPerson\nWHERE sales_id NOT IN (\n    SELECT DISTINCT sales_id\n    FROM Orders\n    WHERE com_id = (\n        
SALES PERSON PROBLEM \n\n\nSELECT name\nFROM SalesPerson\nWHERE sales_id NOT IN (\n    SELECT DISTINCT sales_id\n    FROM Orders\n    WHERE com_id = (\n        SELECT com_id\n        FROM Company\n        WHERE name = \'RED\'\n    )\n);
['MySQL']