select title from film where film\_id in ("highest revenue")

select film\_id from inventory where inventory\_id in (
select inventory\_id from rental group by inventory\_id
order by count(inventory\_id) desc ))

limit (highest revenue);

where im wrong?