Table: election_results_1996_9
Columns: district
incumbent
party
elected
status
result

Question: What was the result of the election for georgia's 3rd district?
SQL: SELECT "result" FROM election_results_1996_9 WHERE "district" = 'Georgia''s 3rd'

Question: Who was the incumbent from georgia's 8th district?
SQL: SELECT "incumbent" FROM election_results_1996_9 WHERE "district" = 'Georgia''s 8th'

Question: What was the result of the election with incumbent bob barr?
SQL: SELECT "result" FROM election_results_1996_9 WHERE "incumbent" = 'Bob Barr'

Question: What was the result of the election with incumbent john lewis?
SQL: SELECT "result" FROM election_results_1996_9 WHERE "incumbent" = 'John Lewis'

Question: Who was the incumbent for the election in 1978?
SQL: SELECT "incumbent" FROM election_results_1996_9 WHERE "elected" = 1978