Movies and actors
You are asked to give an overview of which actors play in which movie.
Latihan ini adalah bagian dari kursus
Data-Driven Decision Making in SQL
Petunjuk latihan
- 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.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
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 = ___;