Get startedGet started for free

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

View Course

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
	___);
Edit and Run Code