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

Show names of musicals and the number of actors who have appeared in the musicals.
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" "T1" JOIN "musical" "T2" ON "T1"."musical_id" = "T2"."musical_id" GROUP BY "T1"."musical_id"