Which Rank has a 2nd run of 1:17.170 (8)?
CREATE TABLE "semifinal_1" (
  "rank" real,
  "name" text,
  "1st_run" text,
  "2nd_run" text,
  "3rd_run" text,
  "total" real
);
SELECT MAX("rank") FROM "semifinal_1" WHERE "2nd_run"='1:17.170 (8)';