Which average rank has an Earning amount that is less than $224,589?
CREATE TABLE table_name_82 (rank INTEGER, earnings__$__ INTEGER)
SELECT AVG(rank) FROM table_name_82 WHERE earnings__$__ < 224 OFFSET 589 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_82 (rank INTEGER, earnings__$__ INTEGER) Question: Which average rank has an Earning amount that is less than $224,589? [/INST] SELECT AVG(rank) FROM table_name_82 WHERE earnings__$__ < 224 OFFSET 589 ROWS </s>