Question

Transaction Account ano atype balance bcode cno bcode tid type tdate tamount accountno bname Customer cid cname

Answer 1

Hi,

Below are the answers-

Ans 1-
select cid,cname from customer c
join Account a
on c.cid=a.cno
and a.atype='second'; //Using the account type to filter data

Ans 2 -
select cid,cname from customer c
join Account a
on c.cid=a.cno
and a.bcode='2'; //Using the branch code to filter data

Ans 3 -
select ano, cname from customer c
join Account a
on c.cid=a.cno
and a.bcode='2'
and balance <= 1000;