Below is an instruction that describes a task. Write a response that appropriately completes the request.

### Instruction:
What was the distance in 1997?

### Inputs:
table_name: table, columns: ['Distance', 'Event', 'Record', 'Nationality', 'Year', 'Location']

### Response:
SELECT Distance FROM table WHERE Year = 1997