Which party was re-elected in south carolina 5 district?
CREATE TABLE table_name_2 (party VARCHAR, result VARCHAR, district VARCHAR)
SELECT party FROM table_name_2 WHERE result = "re-elected" AND district = "south carolina 5"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (party VARCHAR, result VARCHAR, district VARCHAR) Question: Which party was re-elected in south carolina 5 district? [/INST] SELECT party FROM table_name_2 WHERE result = "re-elected" AND district = "south carolina 5" </s>