Find the name of accounts whose checking balance is below the average checking balance.
SELECT T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid WHERE T2.balance  <  (SELECT avg(balance) FROM checking)
name of accounts refers to SELECT name; checking balance is below the average checking balance refers to WHERE balance < (SELECT AVG(balance) FROM checking);