MYSQL- with step Explanation 🔥
think step by step:\n\nstep1: I have to find company id with name red:\n\nselect com_id from company where name="RED"\n\n\nnext step 2: I have to find sales_id 
**think step by step:**\n\nstep1: I have to find company id with name red:\n```\nselect com_id from company where name="RED"\n```\n\nnext step 2: I have to find sales_id from order where company which is red\n```\nselect sales_id from orders where com_id in (select com_id from company where name="RED")\n```\n\nnext step 3:I have to find salesman name who\'s orders are not from company red **(nothing bu our ans)**\n```\nselect name from salesperson where sales_id not in(select sales_id from orders where com_id in (select com_id from company where name="RED"));\n```\n\n\n
['MySQL']