Question

✴✴✴HEY COMPUTER✴✴✴                   ✴EXPERTS AND GENEUS✴✴

☠CAN YOU ALL SOVLE THIS☠

HELPING HAND DON'T ANSWER

NO SPAM❤❤

❤❤NO NEED TO DO IT ON COMPUTER  SIMPLY WRITE THE
PROGRAMS ON A COPY AND SENT IT ❤❤

I WILL MARK BRAINLY

Answer 1

Create table Sales(SalesmanNo Varchar(10), SalesmanName varchar2(10), SalesZone varchar2(10), SalesAmount number(10));

insert into Sales values('S001', 'Vinit Sarma', 'North', 150000);

insert into Sales values('S002', 'AryanBarooa','South',200000);

insert into Sales values('S003', 'Virhann kalita','North',3000000);

insert into Sales values('S004', 'Parul Dutta','East', 250000);

insert into Sales values('S005', 'Jatin Gossain', 'West', 287000);

insert into Sales values('S006', Soumya Nath','West',350000);

(i) Display SalesmanNo and SalesmanName of each record;

Select SalesmanNo,SalesmanName from Sales;

(ii) Display SalesmanNo and SalesAmount of North zone:

Select SalesmanNo, SalesAmount from Sales where Saleszone = 'North';

<!--Hope it helps -- >