yes
select balance from savings where custid = 1
what is the total checking and saving balance of all accounts?
select t1.balance + t2.balance from checking as t1 join savings as t2 on t1.custid = t2.custid
what is the sorted list of total checking and savings balance by ascending order?
select t1.balance + t2.balance from checking as t1 join savings as t2 on t1.custid = t2.custid order by t1.balance + t2.balance