Movies and actors
You are asked to give an overview of which actors play in which movie.
Deze oefening maakt deel uit van de cursus
Data-Driven Decision Making in SQL
Oefeninstructies
- Create a list of actor names and movie titles in which they act. Make sure that each combination of actor and movie appears only once.
- Use as an alias for the table
actsinthe two lettersai.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT ___, -- Create a list of movie titles and actor names
___
FROM ___
LEFT JOIN movies AS m
ON m.movie_id = ___
LEFT JOIN actors AS a
ON a.actor_id = ___;