List all the information about musicals.
select * from musical
Show all the names of musicals which have actors.
select name from musical where musical_id in (select musical_id from actor)
What about having no actors?
select name from musical where musical_id not in (select musical_id from actor)