CREATE TABLE table_2182654_6 (no_in_season INT, written_by VARCHAR)

What s the episode number in the season that was written by Nancy Oliver?
SELECT MAX(no_in_season) FROM table_2182654_6 WHERE written_by = "Nancy Oliver"
SELECT MAX("no_in_season") FROM "table_2182654_6" WHERE "Nancy Oliver" = "written_by"