What are the names of customers with accounts, and how many checking accounts do each of them have?
select count(*), t1.name from accounts as t1 join checking as t2 on t1.custid = t2.custid group by t1.name