How many districts had republican Bob Goodlatte as a candidate?
CREATE TABLE table_17503169_1 (district VARCHAR, republican VARCHAR)
SELECT COUNT(district) FROM table_17503169_1 WHERE republican = "Bob Goodlatte"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_17503169_1 (district VARCHAR, republican VARCHAR) Question: How many districts had republican Bob Goodlatte as a candidate? [/INST] SELECT COUNT(district) FROM table_17503169_1 WHERE republican = "Bob Goodlatte" </s>