CREATE TABLE table_name_88 (earnings__ NUMBER, money_list_rank VARCHAR2, year VARCHAR2)

What is the average amount of earnings for years under 2004 and money list rankings of 6?
SELECT AVG(earnings__) AS $_ FROM table_name_88 WHERE money_list_rank = "6" AND year < 2004
SELECT AVG("earnings__") AS "$_" FROM "table_name_88" WHERE "6" = "money_list_rank" AND "year" < 2004