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)
name and id of accounts = SELECT T1.custid, T1.name; checking balance below the maximum checking balance = WHERE T2.balance < (SELECT MAX(balance) FROM checking); accounts and checking balance information stored in two different tables = JOIN is used to combine 'accounts' and 'checking' tables on custid.