Table: election_results_1978
Columns: district
incumbent
party
first_elected
result
candidates

Question: what is the district where the result is re-elected and the incumbent is richard kelly?
SQL: SELECT "district" FROM election_results_1978 WHERE "result" = 'Re-elected' AND "incumbent" = 'Richard Kelly'

Question: what is the district where the candidates are charles edward bennett (d) unopposed?
SQL: SELECT "district" FROM election_results_1978 WHERE "candidates" = 'Charles Edward Bennett (D) Unopposed'

Question: who are the candidates where the incumbent is sam m. gibbons?
SQL: SELECT "candidates" FROM election_results_1978 WHERE "incumbent" = 'Sam M. Gibbons'

Question: how many times was the candidates dan mica (d) 55.3% bill james (r) 44.7%?
SQL: SELECT COUNT("incumbent") FROM election_results_1978 WHERE "candidates" = 'Dan Mica (D) 55.3% Bill James (R) 44.7%'

Question: what was the result where the candidates are sam m. gibbons (d) unopposed?
SQL: SELECT "result" FROM election_results_1978 WHERE "candidates" = 'Sam M. Gibbons (D) Unopposed'

Question: who is the incumbent where the district is florida 9?
SQL: SELECT "incumbent" FROM election_results_1978 WHERE "district" = 'Florida 9'