What are the total checking and saving balances for all accounts?
select t1.balance + t2.balance from checking as t1 join savings as t2 on t1.custid = t2.custid
Show me the the balances FROM greatest to least?
select t1.balance + t2.balance from checking as t1 join savings as t2 on t1.custid = t2.custid order by t1.balance + t2.balance desc
How about FROM least to greatest?
select t1.balance + t2.balance from checking as t1 join savings as t2 on t1.custid = t2.custid order by t1.balance + t2.balance