Efficient- Using 2 Joins, no subquery, no CTE with explanation
\nSELECT s.name\nFROM Orders o\nJOIN company c\nON o.com_id = c.com_id and c.name = \'RED\'\nRIGHT JOIN SalesPerson s\nON o.sales_id = s.sales_id\nWHERE o.sales
```\nSELECT s.name\nFROM Orders o\nJOIN company c\nON o.com_id = c.com_id and c.name = \'RED\'\nRIGHT JOIN SalesPerson s\nON o.sales_id = s.sales_id\nWHERE o.sales_id is NULL \n```\n1st JOIN get the sales_id associated with the company Red\n2nd JOIN on the sales_id with red company on the salesperson table, salesperson/sales_id left unjoined--> resulted in orders\'s sales_id as null
[]