Table: tv_episode_data_42
Columns: series
season
title
directed_by
written_by
original_air_date
production_code

Question: How many original air dates did the episode directed by Bethany rooney have?
SQL: SELECT COUNT("original_air_date") FROM tv_episode_data_42 WHERE "directed_by" = 'Bethany Rooney'

Question: What is the production code for the episode that aired on October 15, 2004?
SQL: SELECT "production_code" FROM tv_episode_data_42 WHERE "original_air_date" = 'October 15, 2004'

Question: What is the original air date for episode graeme clifford directed and lindsay sturman wrote?
SQL: SELECT "original_air_date" FROM tv_episode_data_42 WHERE "directed_by" = 'Graeme Clifford' AND "written_by" = 'Lindsay Sturman'