CREATE TABLE accounts (custid VARCHAR2, name VARCHAR2)
CREATE TABLE checking (balance NUMBER)

Find the name and id of accounts whose checking balance is below the maximum checking balance.
SELECT T1.custid, T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid WHERE T2.balance < (SELECT MAX(balance) FROM checking)
SELECT "T1"."custid", "T1"."name" FROM "accounts" "T1" JOIN "checking" "T2" ON "T1"."custid" = "T2"."custid" AND "T2"."balance" < (SELECT MAX("balance") FROM "checking")