Table: tv_episodes_28
Columns: col
col_2
title
directed_by
written_by
original_air_date
production_code
u_s_viewers_million

Question: What is the production code for the episode written by  J. H. Wyman & Jeff Pinkner?
SQL: SELECT "production_code" FROM tv_episodes_28 WHERE "written_by" = 'J. H. Wyman & Jeff Pinkner'

Question: What is the title of the episode directed by Charles Beeson?
SQL: SELECT "title" FROM tv_episodes_28 WHERE "directed_by" = 'Charles Beeson'

Question: How many original air dates for the episode written by David H. Goodman & Andrew Kreisberg?
SQL: SELECT COUNT("original_air_date") FROM tv_episodes_28 WHERE "written_by" = 'David H. Goodman & Andrew Kreisberg'

Question: What is the most recent episode number written by Matthew Pitts?
SQL: SELECT MAX("col_2") FROM tv_episodes_28 WHERE "written_by" = 'Matthew Pitts'