Which lane has a time less than 49.67, is from Michael Klim and less than 1 rank?
CREATE TABLE "semifinal_1" (
  "rank" real,
  "lane" real,
  "name" text,
  "nationality" text,
  "time" real
);
SELECT MAX("lane") FROM "semifinal_1" WHERE "time"<49.67 AND "name"='michael klim' AND "rank"<1;