SELECT COUNT(*) AS total_movies
FROM film;
SELECT AVG(rental_rate) AS avg_rental_rate
FROM film;
SELECT title, inventory_id
FROM film
WHERE inventory_id > 10;
SELECT customer_id, COUNT(*) AS total_rentals
FROM rental
GROUP BY customer_id;
SELECT film_id, COUNT(*) AS total_rentals
FROM rental
WHERE rental_date >= DATE_SUB(NOW(), INTERVAL 1 MONTH)
GROUP BY film_id
ORDER BY total_rentals DESC
LIMIT 1;
