Table: election_results_1828_2
Columns: district
incumbent
party
first_elected
result
candidates

Question: How many people were first elected when john roane was the incumbent?
SQL: SELECT COUNT("first_elected") FROM election_results_1828_2 WHERE "incumbent" = 'John Roane'

Question: What party did john s. barbour represent?
SQL: SELECT "party" FROM election_results_1828_2 WHERE "incumbent" = 'John S. Barbour'

Question: What was the result of the election featuring andrew stevenson (j) 100%?
SQL: SELECT "result" FROM election_results_1828_2 WHERE "candidates" = 'Andrew Stevenson (J) 100%'

Question: What candidate(s) ran for election when nathaniel h. claiborne was the incumbent?
SQL: SELECT "candidates" FROM election_results_1828_2 WHERE "incumbent" = 'Nathaniel H. Claiborne'