human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: No. in series, No. in season, Title, Directed by, Written by, Original air date
###Question: What s the episode number in the season that was written by Nancy Oliver?
gpt
SELECT MAX No. in season FROM table WHERE Written by = Nancy Oliver