user: ### NOW ANSWER:
Question: How many of the episodes were titled "Guerillas in the Mist"?
Columns: ['No. in series', 'No. in season', 'Title', 'Directed by', 'Written by', 'Original air date', 'U.S. viewers (millions)']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text']
Sample row: [122.0, 1.0, '"Dangerous Son"', 'Sam Hill', 'Marc Dube & Krystal Houghton', 'September24,2007', '15.08']
SQL:

assistant: SELECT COUNT("No. in series") FROM "Table" WHERE "Title" = '"Guerillas in the Mist"';