Table: election_results_2010
Columns: district
incumbent
party
first_elected
result
candidates

Question: Name the incumbent for north carolina 9
SQL: SELECT "incumbent" FROM election_results_2010 WHERE "district" = 'North Carolina 9'

Question: Name the total party for north carolina 7
SQL: SELECT COUNT("party") FROM election_results_2010 WHERE "district" = 'North Carolina 7'

Question: Name the incumbent for sue myrick (r) 69.0% jeff doctor (d) 31.0%
SQL: SELECT "incumbent" FROM election_results_2010 WHERE "candidates" = 'Sue Myrick (R) 69.0% Jeff Doctor (D) 31.0%'

Question: Name the result for north carolina 7
SQL: SELECT "result" FROM election_results_2010 WHERE "district" = 'North Carolina 7'

Question: Name the incumbent for north carolina 9
SQL: SELECT "incumbent" FROM election_results_2010 WHERE "district" = 'North Carolina 9'