How many reasons were given when A. Willis Robertson (D) resigned?
CREATE TABLE table_1847180_3 (reason_for_change VARCHAR, vacator VARCHAR)
SELECT COUNT(reason_for_change) FROM table_1847180_3 WHERE vacator = "A. Willis Robertson (D)"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1847180_3 (reason_for_change VARCHAR, vacator VARCHAR) Question: How many reasons were given when A. Willis Robertson (D) resigned? [/INST] SELECT COUNT(reason_for_change) FROM table_1847180_3 WHERE vacator = "A. Willis Robertson (D)" </s>