Table: tv_show_episode_4
Columns: no
title
directed_by
written_by
original_air_date
production_code
u_s_viewers_million

Question: Who directed the episode with 4.82 million U.S. viewers?
SQL: SELECT "directed_by" FROM tv_show_episode_4 WHERE "u_s_viewers_million" = '4.82'

Question: Who directed the episode that had a production code of 2j5457?
SQL: SELECT "directed_by" FROM tv_show_episode_4 WHERE "production_code" = '2J5457'

Question: What episode number was written by Anthony Sparks?
SQL: SELECT MIN("no") FROM tv_show_episode_4 WHERE "written_by" = 'Anthony Sparks'

Question: What was the production code of the episode written by Anthony Sparks?
SQL: SELECT "production_code" FROM tv_show_episode_4 WHERE "written_by" = 'Anthony Sparks'

Question: What episode number was written by Karin Gist?
SQL: SELECT MAX("no") FROM tv_show_episode_4 WHERE "written_by" = 'Karin Gist'