What account has the maximum checking balance?
select custid from checking where balance = (select max(balance) from checking)
What is the checking balance?
select max(balance) from checking
Show all the account names that have checking balances lower than this.
select t1.name from accounts as t1 join checking as t2 on t1.custid = t2.custid where t2.balance < (select max(balance) from checking)
also provide their ids.
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)