Table: tv_show_episode_2
Columns: no_in_series
no_in_season
title
directed_by
written_by
u_s_viewers_million
original_air_date
production_code

Question: Who directed episode 53 in the series?
SQL: SELECT "directed_by" FROM tv_show_episode_2 WHERE "no_in_series" = 53

Question: What as the production code for the episode directed by Robert Duncan McNeill?
SQL: SELECT "production_code" FROM tv_show_episode_2 WHERE "directed_by" = 'Robert Duncan McNeill'

Question: What episode number of the season had BCW410 as a production code?
SQL: SELECT "no_in_season" FROM tv_show_episode_2 WHERE "production_code" = 'BCW410'

Question: What episode number in the series had 2.77 million U.S. viewers?
SQL: SELECT MAX("no_in_series") FROM tv_show_episode_2 WHERE "u_s_viewers_million" = '2.77'