CREATE TABLE musical (musical_id DECIMAL, name TEXT, year DECIMAL, award TEXT, category TEXT, nominee TEXT, result TEXT)
CREATE TABLE actor (actor_id DECIMAL, name TEXT, musical_id DECIMAL, character TEXT, duration TEXT, age DECIMAL)

How many actors have appeared in each musical?
SELECT T2.name, COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.musical_id = T2.musical_id GROUP BY T1.musical_id
SELECT "T2"."name", COUNT(*) FROM "actor" AS "T1" JOIN "musical" AS "T2" ON "T1"."musical_id" = "T2"."musical_id" GROUP BY "T1"."musical_id"