CREATE TABLE bank (bname VARCHAR, branch_id VARCHAR)
CREATE TABLE loan (branch_id VARCHAR)

Find 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
SELECT SUM("amount"), "T1"."bname" FROM "bank" AS "T1" JOIN "loan" AS "T2" ON "T1"."branch_id" = "T2"."branch_id" GROUP BY "T1"."bname"