Table: tv_episode_data_2
Columns: no_in_series
no_in_season
title
directed_by
written_by
original_air_date
production_code
u_s_viewers_millions

Question: What episode was writted by John A. Norris?
SQL: SELECT "title" FROM tv_episode_data_2 WHERE "written_by" = 'John A. Norris'

Question: How many episodes did David Jackson write and direct?
SQL: SELECT COUNT("written_by") FROM tv_episode_data_2 WHERE "directed_by" = 'David Jackson'