Which Rank has a Nationality of france, and a Name of alain bernard, and a Lane smaller than 6?
CREATE TABLE "semifinal_2" (
  "rank" real,
  "lane" real,
  "name" text,
  "nationality" text,
  "time" real
);
SELECT AVG("rank") FROM "semifinal_2" WHERE "nationality"='france' AND "name"='alain bernard' AND "lane"<6;