What is the average amount of earnings for years under 2004 and money list rankings of 6?
CREATE TABLE table_name_88 (earnings__ INTEGER, money_list_rank VARCHAR, year VARCHAR)
SELECT AVG(earnings__) AS $_ FROM table_name_88 WHERE money_list_rank = "6" AND year < 2004
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_88 (earnings__ INTEGER, money_list_rank VARCHAR, year VARCHAR) Question: What is the average amount of earnings for years under 2004 and money list rankings of 6? [/INST] SELECT AVG(earnings__) AS $_ FROM table_name_88 WHERE money_list_rank = "6" AND year < 2004 </s>