I need to know 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
What is the highest account balance of customers with checking accounts?
select max ( balance ) from checking
What about the lowest account balance with customers with checking accounts?
select min ( balance ) from checking