Table: tv_episode_data_5
Columns: no_in_series
no_in_season
title
directed_by
written_by
original_air_date
u_s_viewers_millions

Question: How many of the episodes were titled "Guerillas in the Mist"?
SQL: SELECT COUNT("no_in_series") FROM tv_episode_data_5 WHERE "title" = '"Guerillas in the Mist"'

Question: What's the series number of the episode that's written by Elizabeth Devine?
SQL: SELECT MIN("no_in_series") FROM tv_episode_data_5 WHERE "written_by" = 'Elizabeth Devine'

Question: When was the episode directed by Carey Meyer aired for the first time?
SQL: SELECT "original_air_date" FROM tv_episode_data_5 WHERE "directed_by" = 'Carey Meyer'

Question: Who is the writer of the episode called "Ambush" (part 1)?
SQL: SELECT "written_by" FROM tv_episode_data_5 WHERE "title" = '"Ambush" (Part 1)'