Task: Text to Code
Input (English): SQL: SELECT name , Count ( * ) FROM ACCOUNTS GROUP BY custid
Feedback: Replace customer id with name , also need to find corresponding checking accounts from checking table .
Output (English): SELECT count(*) ,  T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid  =  T2.custid GROUP BY T1.name