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 actors that have appeared in musical with name 'The Phantom of the Opera'.
SELECT T1.name FROM actor AS T1 JOIN musical AS T2 ON T1.musical_id = T2.musical_id WHERE T2.name = "The Phantom of the Opera"
SELECT "T1"."name" FROM "actor" "T1" JOIN "musical" "T2" ON "T1"."musical_id" = "T2"."musical_id" AND "T2"."name" = "The Phantom of the Opera"