What number episode in the season was directed by Paul Adelstein? 
CREATE TABLE table_27374740_1 (no_in_season INTEGER, directed_by VARCHAR)
SELECT MAX(no_in_season) FROM table_27374740_1 WHERE directed_by = "Paul Adelstein"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_27374740_1 (no_in_season INTEGER, directed_by VARCHAR) Question: What number episode in the season was directed by Paul Adelstein?  [/INST] SELECT MAX(no_in_season) FROM table_27374740_1 WHERE directed_by = "Paul Adelstein" </s>