Bank

create table Branch
    (Bname VARCHAR(15) NOT NULL,
    City VARCHAR(15),
    Bid NUMBER(4) NOT NULL);
insert into Branch values('Pallavaram','Chennai',106);
insert into Branch values('Green Park','Delhi',408);
insert into Branch values('Pallavaram','Chennai',106);
insert into Branch values('Tambaram','Chennai',104);
insert into Branch values('Bombay','Bombay',405);
insert into Branch values('Chrompet','Chennai',105);
insert into Branch values('Chrompet','Chennai',105);
create table Customers
    (Cid NUMBER(4) NOT NULL,
    Cname VARCHAR(20),
    Age int check (Age>15),
    Location VARCHAR(20),
    Bname VARCHAR(15),
    Actno VARCHAR(4));
insert into Customers values(4892,'Vijay',28,'Chennai','Pallavaram','SB90');
insert into Customers values(7294,'Sunil',40,'Delhi','Green Park','SB48');
insert into Customers values(2597,'Prem',35,'Pallavaram','Pallavaram','SB67');
insert into Customers values(3905,'Saajitha',24,'Chennai','Tambaram','SB39');
insert into Customers values(8230,'Anil',32,'Delhi','Bombay','SB05');
insert into Customers values(8462,'Kiran',26,'Chrompet','Chrompet','SB83');
insert into Customers values(2005,'Raj',37,'Saidapet','Pallavaram','SB66');
create table Loan
    (Cid NUMBER(4) NOT NULL,
    Amount NUMBER(8),
    Interest NUMBER(2,2),
    Actno VARCHAR(4));
insert into Loan values(4892,60000,5.5,'SB90');
insert into Loan values(7294,250000,12.2,'SB48');
insert into Loan values(2597,168000,5.5,'SB67');
insert into Loan values(3905,85000,7.12,'SB39');
insert into Loan values(8230,400000,15.0,'SB05');
insert into Loan values(8462,100000,10.0,'SB83');
insert into Loan values(2005,75000,6.5,'SB66');
create table Deposit
    (Actno VARCHAR(4),
    Amount NUMBER(8,2),
    Adate DATE,
    Cid NUMBER(4) NOT NULL);
insert into Deposit values('SB90',100000,'12-dec-2005',4892);
insert into Deposit values('SB48',50000,'17-feb-2010',7294);
insert into Deposit values('SB67',48000,'14-nov-2001',2597);
insert into Deposit values('SB39',105600,'27-mar-1998',3905);
insert into Deposit values('SB05',40500,'12-dec-2010',8230);
insert into Deposit values('SB83',85000,'13-mar-1995',8462);
insert into Deposit values('SB66',200000,'30-oct-2010',2005);
       
update Deposit set Amount=Amount+(Amount*0.1);
update Deposit set Amount=Amount+(Amount*0.1) where Cid=(select Cid from Customers where Bname='Tambaram');
update Deposit set Amount=Amount+(Amount*0.1) where Cid=(select Cid from Customers where Location='Delhi');
update Deposit set Amount=Amount+(Amount*0.1) where Cid=(select Cid from Customers where Location='Delhi' and Bname='Bombay');
update Deposit set Amount=(select Amount from Deposit where Cid=(select Cid from Customers where Cname='Prem')) where Cid=(select Cid from Customers where Cname='Sunil');
update Deposit set Amount=Amount-10 where Cid=(select Cid from Customers where Cname='Anil');
update Deposit set Amount=Amount+10 where Cid=(select Cid from Customers where Cname='Sunil');

select count(Cname) from customers where Cname like 'K%';
select Cid,Actno from Customers;
select Cname from Customers where Bname='Pallavaram';
select Actno,Amount from Deposit where Adate between '2010-01-01' and '2010-12-31';
select Cname,Cid from Customers order by Cid desc;
select Cname,Actno from Customers where Location='Chennai' or Location='Delhi';
select Cname from Customers where Cname like '__a%';
select * from Customers where Location!='Pallavaram';