What was the successor for vacant alabama 3rd?
CREATE TABLE table_2417340_4 (successor VARCHAR, vacator VARCHAR, district VARCHAR)
SELECT successor FROM table_2417340_4 WHERE vacator = "Vacant" AND district = "Alabama 3rd"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2417340_4 (successor VARCHAR, vacator VARCHAR, district VARCHAR) Question: What was the successor for vacant alabama 3rd? [/INST] SELECT successor FROM table_2417340_4 WHERE vacator = "Vacant" AND district = "Alabama 3rd" </s>