What is the rental rate of film titled ALAMO VIDEOTAPE?
select rental_rate from film where title = "ALAMO VIDEOTAPE"
How about the number of times it was rented.
select count(*) from film as t1 join inventory as t2 on t1.film_id = t2.film_id join rental as t3 on t2.inventory_id = t3.inventory_id group by t2.inventory_id where t1.title = "ALAMO VIDEOTAPE"
What is the film title and inventory id of the item in the inventory which was rented most frequently?
select t1.title, t2.inventory_id from film as t1 join inventory as t2 on t1.film_id = t2.film_id join rental as t3 on t2.inventory_id = t3.inventory_id group by t2.inventory_id order by count(*) desc limit 1