Who was the producer for the film directed by 1997?
CREATE TABLE table_40917 (
    "Title" text,
    "Director" text,
    "Producer" text,
    "Production Cost" text,
    "Singapore Gross" text
)
SELECT "Producer" FROM table_40917 WHERE "Director" = '1997'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Who was the producer for the film directed by 1997? ### Input: CREATE TABLE table_40917 (
    "Title" text,
    "Director" text,
    "Producer" text,
    "Production Cost" text,
    "Singapore Gross" text
) ### Response: SELECT "Producer" FROM table_40917 WHERE "Director" = '1997'