Frequent customers
Report a list of customers who frequently rent movies on MovieNow.
Latihan ini adalah bagian dari kursus
Data-Driven Decision Making in SQL
Petunjuk latihan
- List all customer information for customers who rented more than 10 movies.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
SELECT *
FROM customers
___ -- Select all customers with more than 10 movie rentals
(SELECT ___
FROM renting
GROUP BY customer_id
___);