CREATE TABLE savings (custid DECIMAL, balance DECIMAL)
CREATE TABLE checking (custid DECIMAL, balance DECIMAL)
CREATE TABLE accounts (custid DECIMAL, name TEXT)

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" AS "T1" JOIN "savings" AS "T2" ON "T1"."custid" = "T2"."custid" GROUP BY "T1"."name"