Table: canoe_world_records_2
Columns: distance
event
record
nationality
year
location

Question: What was the distance in 1997?
SQL: SELECT "distance" FROM canoe_world_records_2 WHERE "year" = 1997