Table: election_results_1828
Columns: district
incumbent
party
first_elected
result
candidates

Question: how many "Party" are in district south carolina 2?
SQL: SELECT COUNT("party") FROM election_results_1828 WHERE "district" = 'South Carolina 2'

Question: What "party" was re-elected in district South Carolina 7?
SQL: SELECT "party" FROM election_results_1828 WHERE "result" = 'Re-elected' AND "district" = 'South Carolina 7'

Question: who were the "candidate" of South Carolina 6?
SQL: SELECT "candidates" FROM election_results_1828 WHERE "district" = 'South Carolina 6'

Question: Who was the "incumbent" of district south carolina 7?
SQL: SELECT "incumbent" FROM election_results_1828 WHERE "district" = 'South Carolina 7'