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.Â
Create table salesman(
salesman_id number (10),
s_name varchar(20),
city varchar(20),
commission number(10,2)
);
insert into salesman values(5001,’James Hoog’,’New York’,0.15);
insert into salesman values(5002,’Nail Knite’,’New York’,0.13);
Checkout Attachment for full answer.