Table: election_results_2010
Columns: district
incumbent
party
first_elected
result
candidates

Question: What was the result when John Barrow was the incumbent first elected in 2004?
SQL: SELECT "result" FROM election_results_2010 WHERE "first_elected" = 2004 AND "incumbent" = 'John Barrow'

Question: How many incumbents are there in the georgia 8 district when the party is democratic?
SQL: SELECT COUNT("incumbent") FROM election_results_2010 WHERE "party" = 'Democratic' AND "district" = 'Georgia 8'

Question: In what district is the incumbent John Linder?
SQL: SELECT "district" FROM election_results_2010 WHERE "incumbent" = 'John Linder'

Question: What was the result of the Georgia 8 district?
SQL: SELECT "result" FROM election_results_2010 WHERE "district" = 'Georgia 8'

Question: In what district is the incumbent John Linder?
SQL: SELECT "district" FROM election_results_2010 WHERE "incumbent" = 'John Linder'