Table schema:
CREATE TABLE table_27397948_2 (no_in_season INTEGER, no_in_series VARCHAR)

Question: What's the highest season number with a series number of 47?
SQL: SELECT MAX(no_in_season) FROM table_27397948_2 WHERE no_in_series = 47