Database: small_bank_1
Question: What are the customer id and name corresponding to accounts with a checking balance less than the largest checking balance?
SQL:
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)