Table: film_awards_2
Columns: year
award
category
work
result

Question: What was nominated for the Best Movie category?
SQL: SELECT "work" FROM film_awards_2 WHERE "category" = 'best movie'

Question: Which award did Scream receive a nomination and/or win for in 1997?
SQL: SELECT "award" FROM film_awards_2 WHERE "work" = 'scream' AND "year" = 1997

Question: What category was Scream nominated for at the International Horror Guild?
SQL: SELECT "category" FROM film_awards_2 WHERE "work" = 'scream' AND "award" = 'international horror guild'