When the united states has 22 wins and a rank greater than 2, what is the total earnings?
CREATE TABLE table_name_82 (earnings__ INTEGER, rank VARCHAR, country VARCHAR, wins VARCHAR)
SELECT SUM(earnings__) AS $__ FROM table_name_82 WHERE country = "united states" AND wins = 22 AND rank > 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_82 (earnings__ INTEGER, rank VARCHAR, country VARCHAR, wins VARCHAR) Question: When the united states has 22 wins and a rank greater than 2, what is the total earnings? [/INST] SELECT SUM(earnings__) AS $__ FROM table_name_82 WHERE country = "united states" AND wins = 22 AND rank > 2 </s>