CREATE TABLE loan (amount NUMBER, branch_id VARCHAR2)
CREATE TABLE bank (branch_id VARCHAR2, state VARCHAR2)

Find the total amount of loans provided by bank branches in the state of New York.
SELECT SUM(T2.amount) FROM bank AS T1 JOIN loan AS T2 ON T1.branch_id = T2.branch_id WHERE T1.state = 'New York'
SELECT SUM("T2"."amount") FROM "bank" "T1" JOIN "loan" "T2" ON "T1"."branch_id" = "T2"."branch_id" WHERE "T1"."state" = 'New York'