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

Exercise

Analyzing customer behavior

A new advertising campaign is going to focus on customers who rented fewer than 5 movies. Use a correlated query to extract all customer information for the customers of interest.

Instructions 1/2

undefined XP
    1
    2
  • First, count number of movie rentals for customer with customer_id=45. Give the table renting the alias r.