CREATE TABLE table_175980_2 (season VARCHAR2, ranking VARCHAR2)

What seasons had a ranking of #47?
SELECT season FROM table_175980_2 WHERE ranking = "#47"
SELECT "season" FROM "table_175980_2" WHERE "#47" = "ranking"