Which film has the most copies in the inventory? List both title and id.
create table film (title varchar, film_id varchar, PRIMARY KEY (title)); create table inventory (film_id varchar, PRIMARY KEY (film_id))
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