Find the name of the top 3 accounts with the highest saving balance sorted by savings balance in descending order.
select t1.name from accounts as t1 join savings as t2 on t1.custid = t2.custid order by t2.balance desc limit 3
Can you add in their customer IDs to the table please?
select t1.name, t2.custid from accounts as t1 join savings as t2 on t1.custid = t2.custid order by t2.balance desc limit 3
What is the average balance of all accounts?
select avg ( t2.balance ) from accounts as t1 join savings as t2 on t1.custid = t2.custid
What is the name on the account with the third highest saving balance?
select t1.name from accounts as t1 join savings as t2 on t1.custid = t2.custid order by t2.balance desc limit 3