Table: actors_double_nominations_2
Columns: year_ceremony
actor_actress
category
film_title_used_in_nomination
result

Question: What was the film title that emma thompson was the actress nominated for best supporting actress?
SQL: SELECT "film_title_used_in_nomination" FROM actors_double_nominations_2 WHERE "actor_actress" = 'emma thompson' AND "category" = 'best supporting actress'

Question: What category was al pacino nominated for in the film, glengarry glen ross?
SQL: SELECT "category" FROM actors_double_nominations_2 WHERE "actor_actress" = 'al pacino' AND "film_title_used_in_nomination" = 'glengarry glen ross'

Question: What is the year when sigourney weaver was nominated for best actress?
SQL: SELECT "year_ceremony" FROM actors_double_nominations_2 WHERE "category" = 'best actress' AND "actor_actress" = 'sigourney weaver'

Question: What year was holly hunter a nominee?
SQL: SELECT "year_ceremony" FROM actors_double_nominations_2 WHERE "result" = 'nominee' AND "actor_actress" = 'holly hunter'