Tell me the highest overall rank for lane less than 8 and time less than 27.16
CREATE TABLE "heats" (
  "heat_rank" real,
  "lane" real,
  "swimmer" text,
  "country" text,
  "time" real,
  "overall_rank" real
);
SELECT MAX("overall_rank") FROM "heats" WHERE "lane"<8 AND "time"<27.16;