what film has rental fee of 0.99?
select title from film where rental_rate = 0.99
Which of the film has the highest rent fee?
select title from film order by rental_rate desc limit 1
list the films with less than three in inventory
select title from film intersect select t1.title from film as t1 join inventory as t2 on t1.film_id = t2.film_id group by t1.film_id having count ( * ) < 3