What are the names of all the accounts?
select name from accounts
Show the savings balances for all accounts.
select t1.name, t2.balance from accounts as t1 join savings as t2 on t1.custid = t2.custid
Now show me the total by account name.
select sum(t2.balance), t1.name from accounts as t1 join savings as t2 on t1.custid = t2.custid group by t1.name