How many accounts are there in the bank?
select count(*) from accounts
What are the names for each?
select name from accounts
Include the checking and saving balances for each.
select t2.balance, t3.balance, t1.name from accounts as t1 join checking as t2 on t1.custid = t2.custid join savings as t3 on t1.custid = t3.custid