human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: No. in series, No. in season, Title, Directed by, Written by, Original air date, Production code
###Question: How many production codes had a total number in the season of 8?
gpt
SELECT COUNT Production code FROM table WHERE No. in season = 8