CREATE TABLE musical (Name VARCHAR2, Musical_ID VARCHAR2)
CREATE TABLE actor (Name VARCHAR2, Musical_ID VARCHAR2)

Show names of actors and names of musicals they are in.
SELECT T1.Name, T2.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID = T2.Musical_ID
SELECT "T1"."Name", "T2"."Name" FROM "actor" "T1" JOIN "musical" "T2" ON "T1"."Musical_ID" = "T2"."Musical_ID"