Get startedGet started for free

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.

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 ___ -- Select movie IDs with more than 5 views
FROM renting
___
___
Edit and Run Code