SELECT Name FROM musical WHERE Musical_ID NOT IN (SELECT Musical_ID FROM actor)
What are the names of musicals who have no actors?
SELECT Name FROM musical WHERE Musical_ID NOT IN ( SELECT Musical_ID FROM actor )
select name from musical where musical_id not in ( select musical_id from actor )
What are the names of musicals who have no actors ?