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

Question: What was the original air date of the episode titled "Beaver's Pigeons"
SQL: SELECT "original_air_date" FROM tv_episode_data_30 WHERE "title" = '"Beaver''s Pigeons"'

Question: Who wrote the episode with the production code of 942A?
SQL: SELECT "written_by" FROM tv_episode_data_30 WHERE "production_code" = '942A'

Question: What numbered episode of the season was titled "Beaver says Good-Bye"?
SQL: SELECT "no_in_season" FROM tv_episode_data_30 WHERE "title" = '"Beaver Says Good-bye"'

Question: What number episode in the series was titled "Wally's Pug Nose"?
SQL: SELECT "no_in_series" FROM tv_episode_data_30 WHERE "title" = '"Wally''s Pug Nose"'

Question: What was the production code of the episode written by Joe Connelly and Bob Mosher  titled "Beaver Gets Adopted"?
SQL: SELECT "production_code" FROM tv_episode_data_30 WHERE "written_by" = 'Joe Connelly and Bob Mosher' AND "title" = '"Beaver Gets Adopted"'