yes savings balance?
select t1.name from accounts as t1 join savings as t2 on t1.custid = t2.custid order by t2.balance desc limit 1
What is his customer id?
select t1.custid from accounts as t1 join savings as t2 on t1.custid = t2.custid order by t2.balance desc limit 1
What is the customer ID with lowest saving balance?
select custid from savings order by balance asc limit 1
I want saving balance.
select count ( * ) from savings where balance > = 30000