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

Question: What are all the production codes of episodes written by Michael G. Moye?
SQL: SELECT "production_code" FROM tv_episode_data_76 WHERE "written_by" = 'Michael G. Moye'

Question: Who is the writer of episode 13?
SQL: SELECT COUNT("written_by") FROM tv_episode_data_76 WHERE "no_in_season" = 13

Question: Which series number has the production code 7.07?
SQL: SELECT COUNT("no_in_series") FROM tv_episode_data_76 WHERE "production_code" = '7.07'

Question: How many seasons have the production code 7.01 for an episode? 
SQL: SELECT MAX("no_in_season") FROM tv_episode_data_76 WHERE "production_code" = '7.01'

Question: How many episodes in the series are from season 12?
SQL: SELECT "no_in_series" FROM tv_episode_data_76 WHERE "no_in_season" = 12