I want to know the highest rank with placings more than 123 and points greater than 88.06
CREATE TABLE "pairs" (
  "rank" real,
  "name" text,
  "nation" text,
  "points" real,
  "placings" real
);
SELECT MAX("rank") FROM "pairs" WHERE "placings">123 AND "points">88.06;