Table: us_house_georgia_1998
Columns: district
incumbent
party
elected
status
result

Question: What is the district with the incumbent Charlie Norwood?
SQL: SELECT "district" FROM us_house_georgia_1998 WHERE "incumbent" = 'Charlie Norwood'

Question: What is the year elected for incumbent Cynthia Mckinney?
SQL: SELECT "elected" FROM us_house_georgia_1998 WHERE "incumbent" = 'Cynthia McKinney'

Question: How many incumbents were the result of sanford bishop (d) 57% joseph mccormick (r) 43%?
SQL: SELECT COUNT("incumbent") FROM us_house_georgia_1998 WHERE "result" = 'Sanford Bishop (D) 57% Joseph McCormick (R) 43%'

Question: What is the status for district georgia's 10th?
SQL: SELECT "status" FROM us_house_georgia_1998 WHERE "district" = 'Georgia''s 10th'

Question: What is the result of districk georgia's 1st?
SQL: SELECT "result" FROM us_house_georgia_1998 WHERE "district" = 'Georgia''s 1st'

Question: What is the district with the result mac collins (r) unopposed?
SQL: SELECT "district" FROM us_house_georgia_1998 WHERE "result" = 'Mac Collins (R) unopposed'