Name the average earnings for rank of 3 and wins less than 3
CREATE TABLE "leaders" (
  "rank" real,
  "player" text,
  "country" text,
  "earnings" real,
  "events" real,
  "wins" real
);
SELECT AVG("earnings") FROM "leaders" WHERE "rank"=3 AND "wins"<3;