Player of corey pavin, and a Rank larger than 4 involved which highest earnings ($)?
CREATE TABLE "leaders" (
  "rank" real,
  "player" text,
  "country" text,
  "earnings" real,
  "events" real,
  "wins" real
);
SELECT MAX("earnings") FROM "leaders" WHERE "player"='corey pavin' AND "rank">4;