SELECT count(*) ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid GROUP BY T1.name
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
select count ( * ) , t1 . name from accounts as t1 join checking as t2 on t1 . custid = t2 . custid group by t1 . name
Find the number of checking accounts for each account name .