What is the lowest rank for a player earning $71,979?
CREATE TABLE table_name_11 (rank INTEGER, earnings___$__ INTEGER)
SELECT MIN(rank) FROM table_name_11 WHERE earnings___$__ < 71 OFFSET 979 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_11 (rank INTEGER, earnings___$__ INTEGER) Question: What is the lowest rank for a player earning $71,979? [/INST] SELECT MIN(rank) FROM table_name_11 WHERE earnings___$__ < 71 OFFSET 979 ROWS </s>