Table: election_results_1996_2
Columns: district
incumbent
party
first_elected
result
candidates

Question: Who was the incumbent of district Georgia 2?
SQL: SELECT "incumbent" FROM election_results_1996_2 WHERE "district" = 'Georgia 2'

Question: What district is Mac Collins an incumbent in?
SQL: SELECT "district" FROM election_results_1996_2 WHERE "incumbent" = 'Mac Collins'

Question: What's the first elected year of the district who's been the last one to do so?
SQL: SELECT MAX("first_elected") FROM election_results_1996_2

Question: Who were the candidates in the district where Charlie Norwood is the incumbent?
SQL: SELECT "candidates" FROM election_results_1996_2 WHERE "incumbent" = 'Charlie Norwood'