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

What are the names, checking balances, and savings balances for all customers?
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"