What is the average earnings ($) that has meg mallon as the player, with a rank less than 9?
CREATE TABLE "leading_career_money_winners" (
  "rank" real,
  "player" text,
  "country" text,
  "earned" text,
  "earnings" real
);
SELECT AVG("earnings") FROM "leading_career_money_winners" WHERE "player"='meg mallon' AND "rank"<9;