What are the names of actors and the musicals that they are in?
SELECT T1.Name ,  T2.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID
actors and the musicals they are in refers to a JOIN between actor and musical tables based on a common Musical_ID; actor names refers to T1.Name; musical names refers to T2.Name;