how many bank branches are not in the state of New York?
select count(*) from bank where state != "New York"
what is the total number of bank branches?
select count(*) from bank
how many loans are offered by each branch?
select count(*), t1.bname from bank as t1 join loan as t2 on t1.branch_id = t2.branch_id group by t1.bname
what is the total amount of loans offered by each of them?
select sum(amount), t1.bname from bank as t1 join loan as t2 on t1.branch_id = t2.branch_id group by t1.bname