What is the rank of the games that had 9 gold and 9 silvers?
CREATE TABLE table_name_47 (rank VARCHAR, gold VARCHAR, silver VARCHAR)
SELECT rank FROM table_name_47 WHERE gold = "9" AND silver = "9"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (rank VARCHAR, gold VARCHAR, silver VARCHAR) Question: What is the rank of the games that had 9 gold and 9 silvers? [/INST] SELECT rank FROM table_name_47 WHERE gold = "9" AND silver = "9" </s>