Table: us_house_1942_elections_2
Columns: district
incumbent
party
first_elected
result
candidates

Question: Name all the candidates that ran for the seat where Harold D. Cooley is the incumbent?
SQL: SELECT "candidates" FROM us_house_1942_elections_2 WHERE "incumbent" = 'Harold D. Cooley'

Question: How many partys have a candidate first elected in 1923?
SQL: SELECT COUNT("party") FROM us_house_1942_elections_2 WHERE "first_elected" = 1923