Session Ready
Exercise

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.

Instructions 1/2
undefined XP
  • 1
  • 2
  • Select all movie IDs which have more than 5 views.