user: ### NOW ANSWER:
Question: How many production codes had a total number in the season of 8?
Columns: ['No. in series', 'No. in season', 'Title', 'Directed by', 'Written by', 'Original air date', 'Production code']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'real']
Sample row: [77.0, 1.0, '"It\'s a Wonderful Life"', 'David Trainer', 'Linda Wallem', 'September25,2001', 401.0]
SQL:

assistant: SELECT COUNT("Production code") FROM "Table" WHERE "No. in season" = 8.0;