✅ 100% EASY || FAST 🔥|| CLEAN SOLUTION 🌟
IF THIS WILL BE HELPFUL TO YOU, PLEASE UPVOTE !\n# Code\n\n/* Write your PL/SQL query statement below */\nSELECT name FROM SalesPerson  WHERE name NOT IN (SELEC
IF THIS WILL BE HELPFUL TO YOU, PLEASE UPVOTE !\n# Code\n```\n/* Write your PL/SQL query statement below */\nSELECT name FROM SalesPerson  WHERE name NOT IN (SELECT S.name FROM\n\nSalesPerson S, Company C,Orders O WHERE S.sales_id = O.sales_id \n\nAND C.com_id = O.com_id AND C.name=\'RED\')\n```\n![5kej8w.jpg](https://assets.leetcode.com/users/images/10f41a47-844b-429d-85c2-272fa58c348d_1690740406.9111328.jpeg)\n
['Database', 'MySQL', 'Oracle', 'MS SQL Server']