Get startedGet started for free

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

View Course

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
___;
Edit and Run Code