Sql Queries
create table salesman (salesman_id char(6), name char(12), city char(20), commission decimal(2,2));
select * from salesman;
Insert into salesman values('5001', 'James Hoog', 'New York', 0.15)
select * from salesman;
Insert into salesman values('5002 ', 'Nail Knite', 'Paris', 0.13);
select * from salesman;
Insert into salesman values('5005 ', 'Pit Alex', 'london', 0.11);
Insert into salesman values('5003 ', 'Lauson Hen',' ', 0.12);
select * from salesman;
Insert into salesman values('5006 ', 'Mc Lyon ','Paris ', 0.14);
select * from salesman;
Insert into salesman values('5007 ', 'Paul Adam ','Romes ', 0.13);
Insert into salesman values('9007 ', 'Paul Adam ','Romes ', 0.13);
select * from salesman;
create table customer (customer_id char(6), cust_name char(12), city char(20), grade decimal(6), salesman_id char(6));
Insert into customer values('3002', 'Nick Rimando', 'New York', 100, '5001');
Insert into customer values('3005', 'Graham Zusi ', 'California', 200, '5002'
);
Insert into customer values('3001', 'Brad Guzan', 'London ', 0 , '5005'
);
Insert into customer values('3004', 'Fabian Johns', 'Paris ', 300, '5006'
);
Insert into customer values('3001', 'Brad Guzan', 'London ', 0 , '5005'
);
Insert into customer values('3001', 'Brad Guzan', 'London ', 0 , '5005'
);
Insert into customer values('3009', 'Geoff Camero', 'Berlin ', 100, '5003'
);
Insert into customer values('3008', 'Julian Green', 'London ', 300, '5002'
);
|
run
| edit
| history
| help
|
0
|
|
|