Frequent customers
Report a list of customers who frequently rent movies on MovieNow.
This exercise is part of the course
Data-Driven Decision Making in SQL
Exercise instructions
- List all customer information for customers who rented more than 10 movies.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT *
FROM customers
___ -- Select all customers with more than 10 movie rentals
(SELECT ___
FROM renting
GROUP BY customer_id
___);