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

What are the names of actors who have been in the musical titled 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"