CREATE table salesmen(
sid int primary key,
sname text,
scity text,
commision int
);
insert into salesmen(sid,sname,scity,commision) values
(1001,'John','London',12),
(1002,'Samuel','New York',12),
(1003,'Rahul','Berlin',13),
(1004,'Max','Paris',14);
select * from salesmen;
CREATE table customer(
cid int primary key,
ccity text,
cname text,
sid int
);
insert into customer(cid,ccity,cname,sid) values
(10011,'Berlin','Mary',1004),
(10003,'New York','Peter',1002),
(10671,'Mexico','Raymo',1009),
(10356,'Port Blair','Boon',1450);
select "________________________";
select * from customer;
create table orders(
oid int primary key,
odate text,
cid int,
sid int
);
insert into orders(oid, odate, cid, sid)values
(123456, '12/12/25', 10671, 1009),
(345120, '1/3/25',10011,1004),
(123409, '15/10/24', 10671, 8955),
(358891, '9/5/25', 76798, 7896);
select "__________________________";
select * from orders;
select "__________________________";
select customer.cname, salesmen.sname , salesmen.scity from customer join salesmen
on customer.ccity=salesmen.scity;
select "__________________________";
select customer.cname, salesmen.sname from customer join salesmen on customer.sid=
salesmen.sid;
select "__________________________";
select orders.oid, salesmen.sname, customer.cname from orders join customer on orders.cid = customer.cid join salesmen
on orders.sid =salesmen.sid;
select "__________________________";
select orders.oid, customer.cname from orders join customer on customer.cid=orders.cid;
select "__________________________";
select salesmen.scity, salesmen.sname, customer.cname, customer.ccity from salesmen join customer
on customer.ccity=salesmen.scity;
select "__________________________";
select customer.cname, customer.ccity, salesmen.sname, salesmen.commision from customer join salesmen
on salesmen.scity=customer.ccity where salesmen.commision between 12 and 14;
select "__________________________";
select orders.oid, customer.cname, salesmen.sname, salesmen.commision from orders join customer on orders.cid=customer.cid
join salesmen on customer.ccity=salesmen.scity;
select "__________________________";
select customer.cname, orders.oid from customer join orders on customer.cid=orders.cid where orders.odate="15/10/24";
select "__________________________";
