Could you please tell me the names on all accounts in the bank?
select name from accounts
What are the checking and savings balances on those accounts? Could you please sort them by their total balances in descending order?
select t2.balance, t3.balance from accounts as t1 join checking as t2 on t1.custid = t2.custid join savings as t3 on t1.custid = t3.custid order by t2.balance + t3.balance desc