Who was the successor for the new seat?
CREATE TABLE table_2147588_3 (successor VARCHAR, vacator VARCHAR)
SELECT successor FROM table_2147588_3 WHERE vacator = "New seat"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2147588_3 (successor VARCHAR, vacator VARCHAR) Question: Who was the successor for the new seat? [/INST] SELECT successor FROM table_2147588_3 WHERE vacator = "New seat" </s>