Tell me the number of items in the inventory for the film titled "ALI FOREVER".
select count(*) from inventory as t1 join film as t2 on t1.film_id = t2.film_id where t2.title = "ALI FOREVER"
Which film has the most items?
select title from inventory as t1 join film as t2 on t1.film_id = t2.film_id group by t1.film_id order by count(*) desc limit 1
Which store owns most items?
select store_id from inventory group by store_id order by count(*) desc limit 1