What are the actors in the film titled ALONE TRIP?
select t3.first_name, t3.last_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 = "ALONE TRIP"
How about that of the film titled HUNGER ROOF?
select t3.first_name, t3.last_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 = "HUNGER ROOF"
What's the genre name of this film?
select t1.name from category as t1 join film_category as t2 on t1.category_id = t2.category_id join film as t3 on t2.film_id = t3.film_id where t3.title = 'HUNGER ROOF'