Find all films with maximum length or minimum rental duration (compared to all other films).

In other words let L be the maximum film length, and let R be the minimum rental duration in the table film. You need to find all films that have length L or duration R or both length L and duration R.

If a film has either a maximum length OR a minimal rental duration it should appear in the result set. It does not need to have both the maximum length and the minimum duration.

You just need to return the film_id for this query.

Order your results by film_id in ascending order.

film film_id title description release year language_id original_language_i rental_duration rental_rate length replacement_cost category category_id name last_update language language_id name last_update film_category filmid category_id last_update actor actor_id first_name last_name last_update actor_id last_update film_id film_actor