How many lanes have a Nationality of france, and a Rank larger than 8?
CREATE TABLE "semifinal_2" (
  "rank" real,
  "lane" real,
  "athlete" text,
  "nationality" text,
  "time" real
);
SELECT SUM("lane") FROM "semifinal_2" WHERE "nationality"='france' AND "rank">8;