user: ### NOW ANSWER:
Question: Who was the producer for the film directed by 1997?
Columns: ['Title', 'Director', 'Producer', 'Production Cost', 'Singapore Gross']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['1991', '1991', '1991', '1991', '1991']
SQL:

assistant: SELECT "Producer" FROM "Table" WHERE "Director" = '1997';