user: ### NOW ANSWER:
Question: How many episodes with the production code CA106 are there?
Columns: ['Series #', 'Title', 'Directed by', 'Written by', 'Original air date', 'Production code', 'U.S. viewers (million)']
Types: ['real', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [1.0, '"Pilot" "Welcome to the CIA"', 'Tim Matheson', 'Matt Corman & Chris Ord', 'July13,2010', 'CA101', '4.88']
SQL:

assistant: SELECT COUNT("Written by") FROM "Table" WHERE "Production code" = 'CA106';