Tell me the category of the film "ADAPTATION HOLES".
select t2.title from film_category as t1 join film as t2 on t1.film_id = t2.film_id join category as t3 on t1.category_id = t3.category_id where t2.title = "ADAPTATION HOLES"
How about the rental rate of this film?
select rental_rate from film where title = "ADAPTATION HOLES"
tell me which film has the highest rental rate? What is that rate?
select title, rental_rate from film order by rental_rate desc limit 1