user: Question: How many districts had republican Bob Goodlatte as a candidate?
Columns: ['District', 'Incumbent', '2008 Status', 'Democratic', 'Republican', 'Independent Green', 'Libertarian', 'Other Party']
Types: ['real', 'text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [1.0, 'Rob Wittman', 'Re-election', 'Bill Day', 'Rob Wittman', 'None', 'Nathan Larson', 'None']
SQL:

assistant: SELECT COUNT("District") FROM "Table" WHERE "Republican" = 'Bob Goodlatte';