Table: election_results_1828
Columns: district
incumbent
party
first_elected
result
candidates

Question: What was the result for Henry Daniel's race?
SQL: SELECT "result" FROM election_results_1828 WHERE "incumbent" = 'Henry Daniel'

Question: When was Henry Daniel first elected?
SQL: SELECT "first_elected" FROM election_results_1828 WHERE "incumbent" = 'Henry Daniel'

Question: How many first elected years are provided for Thomas P. Moore?
SQL: SELECT COUNT("first_elected") FROM election_results_1828 WHERE "incumbent" = 'Thomas P. Moore'

Question: What district is Joseph Lecompte in office in?
SQL: SELECT "district" FROM election_results_1828 WHERE "incumbent" = 'Joseph Lecompte'