How many games has each stadium held?
CREATE TABLE stadium (
    id VARCHAR
)

CREATE TABLE game (
    stadium_id VARCHAR
)
SELECT T1.id, COUNT(*) FROM stadium AS T1 JOIN game AS T2 ON T1.id = T2.stadium_id GROUP BY T1.id
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: How many games has each stadium held? ### Input: CREATE TABLE stadium (
    id VARCHAR
)

CREATE TABLE game (
    stadium_id VARCHAR
) ### Response: SELECT T1.id, COUNT(*) FROM stadium AS T1 JOIN game AS T2 ON T1.id = T2.stadium_id GROUP BY T1.id