Movies and actors
You are asked to give an overview of which actors play in which movie.
Bu egzersiz
Data-Driven Decision Making in SQL
kursunun bir parçasıdırEgzersiz talimatları
- 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.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
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 = ___;