What is the average amount of earnings for years under 2004 and money list rankings of 6?
CREATE TABLE "lpga_tour_career_summary" (
  "year" real,
  "wins" real,
  "earnings" real,
  "money_list_rank" text,
  "average" real
);
SELECT AVG("earnings") FROM "lpga_tour_career_summary" WHERE "money_list_rank"='6' AND "year"<2004;