CREATE TABLE table_name_2 (party VARCHAR2, result VARCHAR2, district VARCHAR2)

Which party was re-elected in south carolina 5 district?
SELECT party FROM table_name_2 WHERE result = "re-elected" AND district = "south carolina 5"
SELECT "party" FROM "table_name_2" WHERE "district" = "south carolina 5" AND "re-elected" = "result"