Find the number of checking accounts for each account name.
create table checking (custid varchar, PRIMARY KEY (custid)); create table accounts (name varchar, custid varchar, PRIMARY KEY (name))
select count(*), t1.name from accounts as t1 join checking as t2 on t1.custid = t2.custid group by t1.name