Frequent customers
Report a list of customers who frequently rent movies on MovieNow.
Bu egzersiz
Data-Driven Decision Making in SQL
kursunun bir parçasıdırEgzersiz talimatları
- List all customer information for customers who rented more than 10 movies.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT *
FROM customers
___ -- Select all customers with more than 10 movie rentals
(SELECT ___
FROM renting
GROUP BY customer_id
___);