Derived Table
A Subquery in the FROM clause that is treated as a temporary table. MySQL requires it to have an Alias.
SELECT AVG(rental_count)
FROM (
SELECT COUNT(rental_id) AS rental_count
FROM rental GROUP BY customer_id
) AS customer_rentals;
When to use
PS 04 Q1: the inner query counts rentals per customer and is wrapped as AS customer_rentals, so AVG(rental_count) can average those counts.
See PS 04.