Movies and actors
You are asked to give an overview of which actors play in which movie.
Questo esercizio fa parte del corso
Data-Driven Decision Making in SQL
Istruzioni dell'esercizio
- 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.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
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 = ___;