What's the total rank of the lane smaller than 8 with a time of 59.80?
CREATE TABLE "semifinal_1" (
  "rank" real,
  "lane" real,
  "name" text,
  "nationality" text,
  "time" text
);
SELECT SUM("rank") FROM "semifinal_1" WHERE "time"='59.80' AND "lane"<8;