[6] Obtain the cast list for ‘Casablanca’.
what is a cast list?
The cast list is the names of the actors who were in the movie.
Use movieid=11768, (or whatever value you got from the previous question)
答案:
SELECT name FROM actor JOIN casting ON
actor.id = casting.actorid where movieid = (select id from movie where title='Casablanca')