CREATE TABLE savings (custid NUMBER, balance NUMBER)
CREATE TABLE checking (custid NUMBER, balance NUMBER)
CREATE TABLE accounts (custid NUMBER, name CLOB)

Find the total saving balance for each account name.
SELECT SUM(T2.balance), T1.name FROM accounts AS T1 JOIN savings AS T2 ON T1.custid = T2.custid GROUP BY T1.name
SELECT SUM("T2"."balance"), "T1"."name" FROM "accounts" "T1" JOIN "savings" "T2" ON "T1"."custid" = "T2"."custid" GROUP BY "T1"."name"