What is the highest score when the 1st half is smaller than 289 and rank smaller than 61?
CREATE TABLE "ranking_round" (
  "rank" real,
  "archer" text,
  "1st_half" real,
  "2nd_half" real,
  "score" real
);
SELECT MAX("score") FROM "ranking_round" WHERE "1st_half"<289 AND "rank"<61;