CREATE TABLE table_27988382_1 (production_code VARCHAR, no_in_season VARCHAR)

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