What seasons had a ranking of #47?
CREATE TABLE table_175980_2 (season VARCHAR, ranking VARCHAR)
SELECT season FROM table_175980_2 WHERE ranking = "#47"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_175980_2 (season VARCHAR, ranking VARCHAR) Question: What seasons had a ranking of #47? [/INST] SELECT season FROM table_175980_2 WHERE ranking = "#47" </s>