Table: tv_episodes_5
Columns: series
season
title
directed_by
written_by
original_air_date
production_code
u_s_viewers_million

Question: Who directed the episode with production code ca311?
SQL: SELECT "directed_by" FROM tv_episodes_5 WHERE "production_code" = 'CA311'

Question: What is the series episode number of the episode titled "sound and vision"?
SQL: SELECT MAX("series") FROM tv_episodes_5 WHERE "title" = '"Sound and Vision"'

Question: Which episode had 2.75 million viewers in the U.S.?
SQL: SELECT "title" FROM tv_episodes_5 WHERE "u_s_viewers_million" = '2.75'

Question: Who directed the episode with production code ca303?
SQL: SELECT "directed_by" FROM tv_episodes_5 WHERE "production_code" = 'CA303'