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;