SELECT COUNT(*) FROM film WHERE length >
(
SELECT AVG(length) FROM film
);

SELECT COUNT(*) FROM film WHERE rental_rate =
(
SELECT MAX(rental_rate) FROM film
);

(SELECT * FROM film
WHERE rental_rate =
(
SELECT MIN(rental_rate) FROM film
))
INTERSECT
(SELECT * FROM film
WHERE replacement_cost =
(
SELECT MIN(replacement_cost) FROM film
));

SELECT first_name, last_name FROM customer
WHERE customer_id = ANY
(
SELECT customer_id FROM payment WHERE amount =
(
SELECT MAX(amount) FROM payment
));