Table: us_house_2006_election
Columns: district
incumbent
party
first_elected
results

Question: What is the highest First Elected, when Party is "Republican", and when District is "Louisiana 7"?
SQL: SELECT MAX("first_elected") FROM us_house_2006_election WHERE "party" = 'republican' AND "district" = 'louisiana 7'

Question: What is Party, when Results is "Re-Elected", and when District is "Louisiana 5"?
SQL: SELECT "party" FROM us_house_2006_election WHERE "results" = 're-elected' AND "district" = 'louisiana 5'

Question: What is Party, when Incumbent is "Rodney Alexander"?
SQL: SELECT "party" FROM us_house_2006_election WHERE "incumbent" = 'rodney alexander'

Question: What is Results, when First Elected is less than 1988?
SQL: SELECT "results" FROM us_house_2006_election WHERE "first_elected" < 1988

Question: What is Incumbent, when District is "Louisiana 4"?
SQL: SELECT "incumbent" FROM us_house_2006_election WHERE "district" = 'louisiana 4'