1. Learn
    2. /
  2. Courses
    3. /
  3. Data-Driven Decision Making in SQL

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.