Table: election_results_1942
Columns: district
incumbent
party
first_elected
result
candidates

Question: What was the result of Robert L. F. Sikes' election bid?
SQL: SELECT "result" FROM election_results_1942 WHERE "incumbent" = 'Robert L. F. Sikes'

Question: How many districts have an incumbent first elected in 1940?
SQL: SELECT COUNT("district") FROM election_results_1942 WHERE "first_elected" = 1940

Question: How many races involve incumbent Pat Cannon?
SQL: SELECT COUNT("result") FROM election_results_1942 WHERE "incumbent" = 'Pat Cannon'

Question: Which incumbent was first elected in 1940?
SQL: SELECT "incumbent" FROM election_results_1942 WHERE "first_elected" = 1940