CREATE TABLE category (name VARCHAR, category_id VARCHAR)
CREATE TABLE film (film_id VARCHAR, title VARCHAR)
CREATE TABLE film_category (category_id VARCHAR, film_id VARCHAR)

What is the genre name of the film HUNGER ROOF?
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'
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" AND "T3"."title" = 'HUNGER ROOF'