user: ### NOW ANSWER:
Question: What was the distance in 1997?
Columns: ['Distance', 'Event', 'Record', 'Nationality', 'Year', 'Location']
Types: ['text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['200m', 'K1', '33.8s', 'Canada', 2012.0, 'Montreal , Canada']
SQL:

assistant: SELECT "Distance" FROM "Table" WHERE "Year" = 1997.0;