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

Find the name, checking balance and saving balance of all accounts in the bank.
SELECT T2.balance, T3.balance, T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid JOIN savings AS T3 ON T1.custid = T3.custid
SELECT "T2"."balance", "T3"."balance", "T1"."name" FROM "accounts" "T1" JOIN "checking" "T2" ON "T1"."custid" = "T2"."custid" JOIN "savings" "T3" ON "T1"."custid" = "T3"."custid"