What rank is from Japan, has a lane smaller than 7 and a heat smaller than 3?
CREATE TABLE "heats" (
  "rank" real,
  "heat" real,
  "lane" real,
  "name" text,
  "nationality" text,
  "time" text
);
SELECT SUM("rank") FROM "heats" WHERE "nationality"='japan' AND "lane"<7 AND "heat"<3;