When new york 8th is teh district who is the successor?
CREATE TABLE table_2147588_4 (successor VARCHAR, district VARCHAR)
SELECT successor FROM table_2147588_4 WHERE district = "New York 8th"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2147588_4 (successor VARCHAR, district VARCHAR) Question: When new york 8th is teh district who is the successor? [/INST] SELECT successor FROM table_2147588_4 WHERE district = "New York 8th" </s>