What is the total time of the athlete from Canada with a lane less than 8 and a rank less than 8?
CREATE TABLE "semifinal_1" (
  "rank" real,
  "lane" real,
  "name" text,
  "nationality" text,
  "react" real,
  "time" real
);
SELECT COUNT("time") FROM "semifinal_1" WHERE "lane"<8 AND "nationality"='canada' AND "rank"<8;