607_Sales Person
[easy]
Description
Given three tables:salesperson
,company
,orders
.
Output all thenamesin the tablesalesperson
, who didn’t have sales to company 'RED'.
Example Input
Table:salesperson
The table salesperson
holds the salesperson information. Every salesperson has a sales_id and a name.
Table:company
The table company
holds the company information. Every company has a com_id and a name.
Table:orders
The table orders
holds the sales record information, salesperson and customer company are represented by sales_id and com_id.
output
Solution 1: using join
Solution 2: using subquery
Last updated
Was this helpful?