Simple SQL Beginner Friendly
\t#// sub-query will return the id of the salesperson with company name RED and the parent query will not include them\n\tSelect distinct(s.name) from SalesPers
\t#// sub-query will return the id of the salesperson with company name RED and the parent query will not include them\n\tSelect distinct(s.name) from SalesPerson s \n\twhere s.sales_id NOT IN \n\t(select o.sales_id from Company c join Orders o on c.com_id=o.com_id where c.name=\'RED\')
['MySQL']