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

What are the names of customers with accounts, and what are the total savings balances for each?
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"