Table: tv_episode_data_18
Columns: no_in_series
no_in_season
title
directedby
writtenby
originalairdate
production_code
u_s_viewers_million

Question: What episode is titled "Authority Vested"?
SQL: SELECT MAX("no_in_season") FROM tv_episode_data_18 WHERE "title" = '"Authority Vested"'

Question: Who directed the episode titled "Andare Pescare"?
SQL: SELECT "directedby" FROM tv_episode_data_18 WHERE "title" = '"Andare Pescare"'

Question: What episode was directed by Karen Gaviola?
SQL: SELECT MIN("no_in_season") FROM tv_episode_data_18 WHERE "directedby" = 'Karen Gaviola'