user: ### NOW ANSWER:
Question: What's the highest season number with a series number of 47?
Columns: ['No. in Series', 'No. in Season', 'Title', 'Directed by', 'Written by', 'Original air date', 'U.S. viewers (millions)']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text']
Sample row: [45.0, 1.0, '"The Underneath"', 'John Gray', 'John Gray', 'September28,2007', '8.72']
SQL:

assistant: SELECT MAX("No. in Season") FROM "Table" WHERE "No. in Series" = 47.0;