What's the highest season number with a series number of 47?
CREATE TABLE table_27397948_2 (no_in_season INTEGER, no_in_series VARCHAR)
SELECT MAX(no_in_season) FROM table_27397948_2 WHERE no_in_series = 47
<s>[INST] Write mssql query to answer the following question given the database schema. 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? [/INST] SELECT MAX(no_in_season) FROM table_27397948_2 WHERE no_in_series = 47 </s>