Table: tv_episode_data_9
Columns: series
season
title
directed_by
written_by
original_air_date

Question: Name who wrote the episode directed by arthur albert
SQL: SELECT "written_by" FROM tv_episode_data_9 WHERE "directed_by" = 'Arthur Albert'

Question: Name the title that was written by r. scott gemmill
SQL: SELECT "title" FROM tv_episode_data_9 WHERE "written_by" = 'R. Scott Gemmill'

Question: Name who directed the episode for the series number 236
SQL: SELECT "directed_by" FROM tv_episode_data_9 WHERE "series" = 236