SQLAI.ai

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