What is the rank number for a placing of 28.5 and a total less than 92.7?
CREATE TABLE "pairs" (
  "rank" real,
  "name" text,
  "nation" text,
  "placings" text,
  "total" real
);
SELECT COUNT("rank") FROM "pairs" WHERE "placings"='28.5' AND "total"<92.7;