Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE accounts ( custid number, name text )
TABLE: CREATE TABLE checking ( custid number, balance number )
TABLE: CREATE TABLE savings ( custid number, balance number )

### Question ###
What are the names of customers with accounts, and how many checking accounts do each of them have?

### Accurate SQL ###

SELECT COUNT(*), T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid GROUP BY T1.name