Table schema:
CREATE TABLE table_27988382_1 (production_code VARCHAR, no_in_season VARCHAR)

Question: How many production codes had a total number in the season of 8?
SQL: SELECT COUNT(production_code) FROM table_27988382_1 WHERE no_in_season = 8