Which Athlete has a Rank larger than 1, and a Lane larger than 7, and a Nationality of china?
CREATE TABLE "semifinal_2" (
  "rank" real,
  "lane" real,
  "athlete" text,
  "nationality" text,
  "time" real
);
SELECT "athlete" FROM "semifinal_2" WHERE "rank">1 AND "lane">7 AND "nationality"='china';