Identify favorite movies for a group of customers
Which is the favorite movie on MovieNow? Answer this question for a specific group of customers: for all customers born in the 70s.
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.
SELECT *
FROM renting AS r
LEFT JOIN ___ -- Add customer information
___
LEFT JOIN ___ -- Add movie information
___;