Find the number of checking accounts for each account name.
SELECT count(*) ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid GROUP BY T1.name
number of checking accounts for each account name refers to COUNT(*) GROUP BY account_name; account name refers to T1.name; checking accounts are determined by a JOIN between accounts and checking tables on customer ID (custid).