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

Question: Who was the writters for the episode directed by Richard L. Bare, no. 8 in season?
SQL: SELECT "written_by" FROM episodes_table_2 WHERE "directed_by" = 'Richard L. Bare' AND "no_in_season" = 8

Question: How many episodes had a title "the great mayoralty campaign"?
SQL: SELECT COUNT("directed_by") FROM episodes_table_2 WHERE "title" = '"The Great Mayoralty Campaign"'