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