Sql Queries, Sql Server

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