user: Question: What seasons had a ranking of #47?
Columns: ['Season', 'Timeslot', 'Premiere', 'Finale', 'TV season', 'Ranking', 'Viewers (in millions)']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['1st', 'Wednesday 8:30 p.m.', 'October 3, 2001', 'May 15, 2002', '2001–2002', '#55', '10.0']
SQL:

assistant: SELECT "Season" FROM "Table" WHERE "Ranking" = '#47';