Table: election_results_1824
Columns: district
incumbent
party
first_elected
result
candidates

Question: What party does joel r. poinsett represent?
SQL: SELECT "party" FROM election_results_1824 WHERE "incumbent" = 'Joel R. Poinsett'

Question: What was the first elected year that featured incumbent andrew r. govan?
SQL: SELECT "first_elected" FROM election_results_1824 WHERE "incumbent" = 'Andrew R. Govan'