view: 1: CREATE VIEW FilmPopularitySummary AS SELECT f.film_id, f.title, f.rating, COUNT(r.rental_id) AS total_rentals FROM film AS f LEFT JOIN inventory AS i ON f.film_id = i.film_id LEFT JOIN rental AS r ON i.inventory_id = r.inventory_id GROUP BY f.film_id, f.title, f.rati…
January 5, 2025 194 3
