user: ### NOW ANSWER:
Question: How many episodes had a title "The Great Mayoralty Campaign"?
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: [145.0, 1.0, '"The City Kids"', 'Richard L. Bare', 'Jay Sommers and Dick Chevillat', 'September15,1970', 146.0]
SQL:

assistant: SELECT COUNT("Directed by") FROM "Table" WHERE "Title" = '"The Great Mayoralty Campaign"';