Manish SQL , Sql Server

Manish SQL

Language: Layout:

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'
);
Insert into customer values('3003',         'Jozy Altidor',  'Moscow    ',  200,         '5007'
);
Select * from Customer;
Delete from customer where cust_name = '	Brad Guzan ';
Select * from Customer;
Delete from customer where cust_name = 'Brad Guzan';
Select * from Customer;
Insert into customer values('3001',         'Brad Guzan',    'London    ',  0    ,        '5005');
Insert into customer values('3007',         'Brad Davis ',   'New York  ',  200,         '5001');
Select * from Customer;
create table order1 (ord_no decimal(7,0), purch_amt decimal(6,2),   ord_date date,    customer_id char(6),  salesman_id char(6));
Insert into order1 values(70001,      150.5,       '2012-10-05',   '3005',  '5002');
Insert into order1 values(70009,       270.65,      '2012-09-10',  '3001 ',        '5005');
Insert into order1 values(70002,      65.26,       '2012-10-05',   '3002 ',        '5001');
Select * from order1;
Insert into order1 values(70007,       948.5,       '2012-09-10',  '3005 ',        '5002');
Select * from order1;
Insert into order1 values(70004,      110.5,       '2012-08-17',   '3009 ',        '5003');
Insert into order1 values(70005,       2400.6,      '2012-07-27',  '3007 ',        '5001');
Insert into order1 values(70008,       5760,        '2012-09-10',  '3002 ',        '5001');
Insert into order1 values(70010,       1983.43,     '2012-10-10',  '3004 ',        '5006');
Insert into order1 values(70003,       2480.4,      '2012-10-10',  '3009 ',        '5003');
Insert into order1 values(70012,       250.45,      '2012-06-27',  '3008 ',        '5002');
Insert into order1 values(70011,       75.29 ,      '2012-08-17',  '3003 ',        '5007');
Insert into order1 values(70013,       3045.6,      '2012-04-25',  '3002 ',        '5001');
Select * from order1;

View schema
Execution time: 0,03 sec, rows selected: 70, rows affected: 33, absolute service time: 0,23 sec

	salesman_id	name	city	commission
1	5001	James Hoog	New York	0,15

	salesman_id	name	city	commission
1	5001	James Hoog	New York	0,15
2	5002	Nail Knite	Paris	0,13

	salesman_id	name	city	commission
1	5001	James Hoog	New York	0,15
2	5002	Nail Knite	Paris	0,13
3	5005	Pit Alex	london	0,11
4	5003	Lauson Hen		0,12

	salesman_id	name	city	commission
1	5001	James Hoog	New York	0,15
2	5002	Nail Knite	Paris	0,13
3	5005	Pit Alex	london	0,11
4	5003	Lauson Hen		0,12
5	5006	Mc Lyon	Paris	0,14

	salesman_id	name	city	commission
1	5001	James Hoog	New York	0,15
2	5002	Nail Knite	Paris	0,13
3	5005	Pit Alex	london	0,11
4	5003	Lauson Hen		0,12
5	5006	Mc Lyon	Paris	0,14
6	5007	Paul Adam	Romes	0,13
7	9007	Paul Adam	Romes	0,13

	customer_id	cust_name	city	grade	salesman_id
1	3002	Nick Rimando	New York	100	5001
2	3005	Graham Zusi	California	200	5002
3	3001	Brad Guzan	London	0	5005
4	3004	Fabian Johns	Paris	300	5006
5	3001	Brad Guzan	London	0	5005
6	3001	Brad Guzan	London	0	5005
7	3009	Geoff Camero	Berlin	100	5003
8	3008	Julian Green	London	300	5002
9	3003	Jozy Altidor	Moscow	200	5007

	customer_id	cust_name	city	grade	salesman_id
1	3002	Nick Rimando	New York	100	5001
2	3005	Graham Zusi	California	200	5002
3	3001	Brad Guzan	London	0	5005
4	3004	Fabian Johns	Paris	300	5006
5	3001	Brad Guzan	London	0	5005
6	3001	Brad Guzan	London	0	5005
7	3009	Geoff Camero	Berlin	100	5003
8	3008	Julian Green	London	300	5002
9	3003	Jozy Altidor	Moscow	200	5007

	customer_id	cust_name	city	grade	salesman_id
1	3002	Nick Rimando	New York	100	5001
2	3005	Graham Zusi	California	200	5002
3	3004	Fabian Johns	Paris	300	5006
4	3009	Geoff Camero	Berlin	100	5003
5	3008	Julian Green	London	300	5002
6	3003	Jozy Altidor	Moscow	200	5007

	customer_id	cust_name	city	grade	salesman_id
1	3002	Nick Rimando	New York	100	5001
2	3005	Graham Zusi	California	200	5002
3	3001	Brad Guzan	London	0	5005
4	3004	Fabian Johns	Paris	300	5006
5	3007	Brad Davis	New York	200	5001
6	3009	Geoff Camero	Berlin	100	5003
7	3008	Julian Green	London	300	5002
8	3003	Jozy Altidor	Moscow	200	5007

	ord_no	purch_amt	ord_date	customer_id	salesman_id
1	70001	150,50	05.10.2012 00:00:00	3005	5002
2	70009	270,65	10.09.2012 00:00:00	3001	5005
3	70002	65,26	05.10.2012 00:00:00	3002	5001

	ord_no	purch_amt	ord_date	customer_id	salesman_id
1	70001	150,50	05.10.2012 00:00:00	3005	5002
2	70009	270,65	10.09.2012 00:00:00	3001	5005
3	70002	65,26	05.10.2012 00:00:00	3002	5001
4	70007	948,50	10.09.2012 00:00:00	3005	5002

	ord_no	purch_amt	ord_date	customer_id	salesman_id
1	70001	150,50	05.10.2012 00:00:00	3005	5002
2	70009	270,65	10.09.2012 00:00:00	3001	5005
3	70002	65,26	05.10.2012 00:00:00	3002	5001
4	70007	948,50	10.09.2012 00:00:00	3005	5002
5	70004	110,50	17.08.2012 00:00:00	3009	5003
6	70005	2400,60	27.07.2012 00:00:00	3007	5001
7	70008	5760,00	10.09.2012 00:00:00	3002	5001
8	70010	1983,43	10.10.2012 00:00:00	3004	5006
9	70003	2480,40	10.10.2012 00:00:00	3009	5003
10	70012	250,45	27.06.2012 00:00:00	3008	5002
11	70011	75,29	17.08.2012 00:00:00	3003	5007
12	70013	3045,60	25.04.2012 00:00:00	3002	5001