What are the names, checking balances, and savings balances for all customers?
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
names refer to T1.name; checking balances refer to T2.balance where T2 represents a checking account; savings balances refer to T3.balance where T3 represents a savings account; customers are identified by custid; all customers implies no WHERE clause to filter results;