Table: episodes_table_7
Columns: 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?
SQL: SELECT MAX("no_in_season") FROM episodes_table_7 WHERE "written_by" = 'Nancy Oliver'

Question: What date was episode 10 in the season originally aired?
SQL: SELECT "original_air_date" FROM episodes_table_7 WHERE "no_in_season" = 10

Question: What was the name of the episode that was directed by Mary Harron?
SQL: SELECT "title" FROM episodes_table_7 WHERE "directed_by" = 'Mary Harron'