Task: Text to Code
Input (English): Step 1: find the maximum balance in CHECKING table.
Step 2: find the name, ACCOUNTS's custid of ACCOUNTS table whose ACCOUNTS's custid less than the results of step 1
Output (English): SELECT T1.name , T1.custid FROM ACCOUNTS AS T1 WHERE T1.custid < ( SELECT Max ( T2.balance ) FROM CHECKING AS T2 )