Who is from the united states, has a rank less than 9, and heat more than 5?
CREATE TABLE "heats" (
  "rank" real,
  "heat" real,
  "lane" real,
  "name" text,
  "nationality" text,
  "time" text
);
SELECT "name" FROM "heats" WHERE "rank"<9 AND "heat">5 AND "nationality"='united states';