Which Time has a Lane smaller than 4, and a Rank larger than 6?
CREATE TABLE "semifinal_2" (
  "rank" real,
  "lane" real,
  "name" text,
  "nationality" text,
  "time" real
);
SELECT AVG("time") FROM "semifinal_2" WHERE "lane"<4 AND "rank">6;