What is the genre name of the film HUNGER ROOF, please?
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'
How many other films have that same genre name?
select count ( * ) 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 t1.name = "Foreign"
Of those films, which ones have the special features Deleted Scenes?
select count ( * ) 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 t1.name = "Foreign" and t3.special_features = "Deleted Scenes"
What about the special features Trailers?
select count ( * ) 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 t1.name = "Foreign" and t3.special_features = "Trailers"
What about films of the genre Action?
select count ( * ) 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 t1.name = "Foreign" and t3.special_features = "Action"