Movies and actors
You are asked to give an overview of which actors play in which movie.
This exercise is part of the course
Data-Driven Decision Making in SQL
Exercise instructions
- 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.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
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 = ___;