for the rank of 8 and lane less than 3 what is the name?
CREATE TABLE "semifinal_2" (
  "rank" real,
  "lane" real,
  "name" text,
  "nationality" text,
  "time" real
);
SELECT "name" FROM "semifinal_2" WHERE "lane"<3 AND "rank"=8;