Table: house_1974_elections
Columns: district
incumbent
party
first_elected
result
candidates

Question: How many incumbents are there in district Louisiana 5?
SQL: SELECT COUNT("incumbent") FROM house_1974_elections WHERE "district" = 'Louisiana 5'

Question: How many incumbents resulted in a lost renomination republican gain?
SQL: SELECT COUNT("incumbent") FROM house_1974_elections WHERE "result" = 'Lost renomination Republican gain'

Question: In which district is the incumbent John Breaux?
SQL: SELECT "district" FROM house_1974_elections WHERE "incumbent" = 'John Breaux'

Question: What year was Otto Passman (d) unopposed first elected?
SQL: SELECT MAX("first_elected") FROM house_1974_elections WHERE "candidates" = 'Otto Passman (D) Unopposed'

Question: What were the results when the incumbent was John Breaux?
SQL: SELECT "result" FROM house_1974_elections WHERE "incumbent" = 'John Breaux'