Tell me the actors' first name in the film "ACE GOLDFINGER".
select t3.first_name from film_actor as t1 join film as t2 on t1.film_id = t2.film_id join actor as t3 on t1.actor_id = t3.actor_id where t2.title = "ACE GOLDFINGER"
What is the rental fee of this film?
select rental_rate from film where title = "ACE GOLDFINGER"
Which film is rented at a fee of 0.99 and has less than 3 in the inventory? List the film title and id.
select title, film_id from film where rental_rate = 0.99 intersect 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 having count(*) < 3