How many savings accounts are there?
select count(custid) from accounts
What are their saving balances?
select t2.balance from accounts as t1 join savings as t2 on t1.custid = t2.custid
Remove Brown's saving balance.
select t2.balance from accounts as t1 join savings as t2 on t1.custid = t2.custid where t1.name != "Brown"
What is the total of these saving balances?
select sum(t2.balance) from accounts as t1 join savings as t2 on t1.custid = t2.custid where t1.name != 'Brown'