How many production codes had a total number in the season of 8?
CREATE TABLE table_27988382_1 (production_code VARCHAR, no_in_season VARCHAR)
SELECT COUNT(production_code) FROM table_27988382_1 WHERE no_in_season = 8
<s>[INST] Write mssql query to answer the following question given the database schema. 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? [/INST] SELECT COUNT(production_code) FROM table_27988382_1 WHERE no_in_season = 8 </s>