Which district did Ralph Harvey (r) vacated when he resigned?
CREATE TABLE table_1847180_4 (district VARCHAR, vacator VARCHAR)
SELECT district FROM table_1847180_4 WHERE vacator = "Ralph Harvey (R)"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1847180_4 (district VARCHAR, vacator VARCHAR) Question: Which district did Ralph Harvey (r) vacated when he resigned? [/INST] SELECT district FROM table_1847180_4 WHERE vacator = "Ralph Harvey (R)" </s>