Consider the following relations:

 

Salesman

salesman_id | name | city | commission

————-+————+———-+————

5001 | James Hoog | New York | 0.15

5002 | Nail Knite | Paris | 0.13

5005 | Pit Alex | London | 0.11

5006 | Mc Lyon | Paris | 0.14

5007 | Paul Adam | Rome | 0.13

5003 | Lauson Hen | San Jose | 0.12

 

Customer

customer_id | cust_name | city | grade | salesman_id

————-+—————-+————+——-+————-

3002 | Nick Rimando | New York | 100 | 5001

3007 | Brad Davis | New York | 200 | 5001

3005 | Graham Zusi | California | 200 | 5002

3008 | Julian Green | London | 300 | 5002

3004 | Fabian Johnson | Paris | 300 | 5006

3009 | Geoff Cameron | Berlin | 100 | 5003

3003 | Jozy Altidor | Moscow | 200 | 5007

3001 | Brad Guzan | London | | 5005

 

Orders

ord_no purch_amt ord_date customer_id salesman_id

———- ———- ———- ———– ———–

70001 150.5  2012-10-05      3005   5002

70009 270.65 2012-09-10     3001     5005

70002  65.26   2012-10-05       3002  5001

70004  110.5   2012-08-17       3009  5003

70007 948.5  2012-09-10      3005   5002

70005 2400.6 2012-07-27     3007     5001

70008 5760     2012-09-10     3002     5001

70010  1983.43 2012-10-10      3004  5006

70003 2480.4  2012-10-10     3009   5003

70012 250.45  2012-06-27      3008   5002

70011 75.29  2012-08-17       3003   5007

70013  3045.6 2012-04-25      3002   5001

 

Write a query to create a view that shows for each order the salesman and customer by name.