which is the most rented film title and how many times it has been rented
SELECT title, COUNT(*) as total_rentals
FROM film_list
JOIN rental ON rental.inventory_id = film_list.fid
GROUP BY title
ORDER BY total_rentals DESC
LIMIT 1;
- Public
- ·
- Thu, 02 Mar 2023 18:46:56 GMT