Yes, please.
select t2.loan_type, t1.bname, t2.branch_id, t2.amount from bank as t1 join loan as t2 on t1.branch_id = t2.branch_id group by t1.bname
Yes please.
select branch_id, bname, no_of_customers from bank
Please find out the total amount of loans offered by each bank branch.
select sum ( amount ), t1.bname from bank as t1 join loan as t2 on t1.branch_id = t2.branch_id group by t1.bname