Often rented movies
Your manager wants you to make a list of movies excluding those which are hardly ever watched. This list of movies will be used for advertising. List all movies with more than 5 views using a nested query which is a powerful tool to implement selection conditions.
Deze oefening maakt deel uit van de cursus
Data-Driven Decision Making in SQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT ___ -- Select movie IDs with more than 5 views
FROM renting
___
___