CREATE TABLE table_name_42 (producer VARCHAR2, director VARCHAR2)

Who was the producer for the film directed by 1997?
SELECT producer FROM table_name_42 WHERE director = "1997"
SELECT "producer" FROM "table_name_42" WHERE "1997" = "director"