SELECT T1.title ,  T1.film_id FROM film AS T1 JOIN inventory AS T2 ON T1.film_id  =  T2.film_id GROUP BY T1.film_id ORDER BY count(*) DESC LIMIT 1
What is the title and id of the film that has the greatest number of copies in inventory?
SELECT T1.title , T1.film_id FROM film AS T1 JOIN inventory AS T2 ON T1.film_id = T2.film_id GROUP BY T1.film_id ORDER BY count ( * ) DESC LIMIT 1
select t1 . title , t1 . film_id from film as t1 join inventory as t2 on t1 . film_id = t2 . film_id group by t1 . film_id order by count ( * ) desc limit value
What is the title and id of the film that has the greatest number of copies in inventory ?