Table: episode_data_42
Columns: no_in_series
no_in_season
title
directed_by
written_by
original_air_date

Question: Who are all writers with original air date of October 23, 1996?
SQL: SELECT "written_by" FROM episode_data_42 WHERE "original_air_date" = 'October 23, 1996'

Question: How many titles have directors of matthew Penn and number in series of 143?
SQL: SELECT COUNT("title") FROM episode_data_42 WHERE "directed_by" = 'Matthew Penn' AND "no_in_series" = 143

Question: How many numbers in series were for the number in season of 8?
SQL: SELECT COUNT("no_in_series") FROM episode_data_42 WHERE "no_in_season" = 8