Beginner Logical Solution | Explanation
Started with the nested query first\n\n select s.name\n    from SalesPerson s\n        left join Orders o on s.sales_id = o.sales_id\n        left join Company 
Started with the nested query first\n```\n select s.name\n    from SalesPerson s\n        left join Orders o on s.sales_id = o.sales_id\n        left join Company c on o.com_id = c.com_id\n    where c.name = \'Red\'\n```\nThis queried all salespersons who is associated with the company Red\nThen, I added the `NOT IN ` Where condition:\n\n```\nselect s.name\nfrom SalesPerson s\nwhere s.name not in\n    (select s.name\n    from SalesPerson s\n        left join Orders o on s.sales_id = o.sales_id\n        left join Company c on o.com_id = c.com_id\n    where c.name = \'Red\')\n```\n\n*Please upvote if you find this helpful!*
['MySQL']