Table: episode_data_8
Columns: no_in_series
no_in_season
title
directed_by
written_by
original_air_date
production_code

Question: How many episodes in the season are episode 142 in the series?
SQL: SELECT COUNT("no_in_season") FROM episode_data_8 WHERE "no_in_series" = 142

Question: What episode number in the season is "parent trap"?
SQL: SELECT "no_in_season" FROM episode_data_8 WHERE "title" = '"Parent Trap"'

Question: What is the name of the episode that William M. Finkelstein wrote?
SQL: SELECT "title" FROM episode_data_8 WHERE "written_by" = 'William M. Finkelstein'