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.
Questo esercizio fa parte del corso
Data-Driven Decision Making in SQL
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
SELECT ___ -- Select movie IDs with more than 5 views
FROM renting
___
___