Find the number of checking accounts for each account name.
CREATE TABLE checking (
    custid VARCHAR
)

CREATE TABLE accounts (
    name VARCHAR,
    custid VARCHAR
)
SELECT COUNT(*), T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid GROUP BY T1.name
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the number of checking accounts for each account name. ### Input: CREATE TABLE checking (
    custid VARCHAR
)

CREATE TABLE accounts (
    name VARCHAR,
    custid VARCHAR
) ### Response: SELECT COUNT(*), T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid GROUP BY T1.name