Table: actors_double_nominations
Columns: year_ceremony
actor_actress
category
film_title_used_in_nomination
result

Question: In the film Mrs. Miniver, what is the actresses name?
SQL: SELECT "actor_actress" FROM actors_double_nominations WHERE "film_title_used_in_nomination" = 'Mrs. Miniver'

Question: What year was Teresa Wright nominated best supporting actress?
SQL: SELECT "year_ceremony" FROM actors_double_nominations WHERE "actor_actress" = 'Teresa Wright' AND "category" = 'Best Supporting Actress'

Question: What category was the movie Working Girl nominated?
SQL: SELECT "category" FROM actors_double_nominations WHERE "film_title_used_in_nomination" = 'Working Girl'

Question: Who was nominated for best supporting actor in the movie Going My Way?
SQL: SELECT "actor_actress" FROM actors_double_nominations WHERE "film_title_used_in_nomination" = 'Going My Way' AND "category" = 'Best Supporting Actor'