What was the distance in 1997?
CREATE TABLE "men_kayak" (
  "distance" text,
  "event" text,
  "record" text,
  "nationality" text,
  "year" real,
  "location" text
);
SELECT "distance" FROM "men_kayak" WHERE "year"=1997;