Which nation has a heat of 4, and is ranked 8?
CREATE TABLE "semifinals" (
  "rank" real,
  "heat" real,
  "cyclist" text,
  "nation" text,
  "result" text
);
SELECT "nation" FROM "semifinals" WHERE "heat"=4 AND "rank"=8;