Customer preference for actors
The last aspect you have to analyze are customer preferences for certain actors.
This exercise is part of the course
Data-Driven Decision Making in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Join the tables
SELECT *
FROM renting AS r
LEFT JOIN actsin AS ai
___
LEFT JOIN actors AS a
___;