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