Table: us_house_1974_elections
Columns: district
incumbent
party
first_elected
result
candidates

Question: What candidates ran in the election with don fuqua?
SQL: SELECT "candidates" FROM us_house_1974_elections WHERE "incumbent" = 'Don Fuqua'

Question: How many incumbent candidates in the election featuring sam m. gibbons (d) unopposed?
SQL: SELECT COUNT("incumbent") FROM us_house_1974_elections WHERE "candidates" = 'Sam M. Gibbons (D) Unopposed'

Question: What is the last year that someone is first elected?
SQL: SELECT MAX("first_elected") FROM us_house_1974_elections

Question: Who was the incumbent in 1940?
SQL: SELECT "incumbent" FROM us_house_1974_elections WHERE "first_elected" = 1940