How many actors have appeared in each musical?
CREATE TABLE musical (
    musical_id number,
    name text,
    year number,
    award text,
    category text,
    nominee text,
    result text
)

CREATE TABLE actor (
    actor_id number,
    name text,
    musical_id number,
    character text,
    duration text,
    age number
)
SELECT T2.name, COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.musical_id = T2.musical_id GROUP BY T1.musical_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 actors have appeared in each musical? ### Input: CREATE TABLE musical (
    musical_id number,
    name text,
    year number,
    award text,
    category text,
    nominee text,
    result text
)

CREATE TABLE actor (
    actor_id number,
    name text,
    musical_id number,
    character text,
    duration text,
    age number
) ### Response: SELECT T2.name, COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.musical_id = T2.musical_id GROUP BY T1.musical_id